I am trying to find out how I can insert rows into a table based on another table being updated. I am not interested in triggers as this is a manual process.
So what I would like is to retrieve the primary keys of the update rows in the table being updated then insert a new row in another table whilst using the returned values as a field value for the table being inserting into.
UPDATE tblA SET field1="Test" WHERE id=1 ANd id =2;
INSERT INTO tblB (field2)
("Getprimary key values from tblA above")
Thank you for your help on this matter