Access 2013 - Desktop database
I'm attempting to copy selected records from one table (A) to another (B) dependent on yet another table (C)
Each table has the field "idnumber" which is a long integer. IN fact all fields in all tables are the same.
C has the controlling list of idnumbers
I want to copy records from A into B if a.idnumber is in the c table.
INSERT INTO B select * from A where A.idnumber in (select idnumber from c);
but it copies every record in A . I tried a couple of other techniques but no joy.
(Yes, I need a separate copy of the records in a table since I'm using table B in other databases via linked.
ideas? does anyone have the specific statement which might work?