I need select the RecID field from one table then do an insert into another table fore each row that was found. Any examples of that?
My select will be:
Select RecID from Meta where username = 'jdoe'
I want to loop through those then do this insert:
Insert into Publishers (fkRecID, PRO_Name) values (RecID_From_Loop, 'XYZ')