Find missing records and append 1

[Lost500]

Hello all!
I would like to create a query to compare the ID fields in two tables and find which records are missing in table B (table A has them all) and append them to table B leaving both tables with all the same ID numbers.

Table A is the Primary key including all ID numbers and Table B has most of the records with additional information so i cant just cut and paste. only the id field needs to be appended. I need to do this so that i can create a relationship between the two tables that will cascade any changes/deletes/additions so this wont happen again!

I know the correct course of action is to create the relationship when the tables are created so that they will always have the same ID numbers but, i get handed alot of crap so here we are

Please adivise and thanks in advance y'all are great.

 

[Remou]

I guess something on the lines of:

INSERT INTO TableB ( ID )
SELECT ID FROM TableA
LEFT JOIN TableB
ON TableA.ID=TableB.ID
WHERE TableB.ID Is Null

http://lessthandot.com

 

[Lost500]

Thanks Remou that got me pointed in the right direction and ended up working great