I have two tables with same columns but not all same rows.
first column in both tables is ID
In first table i defined first column as primary key.
What i need to do is to compare first columns from both tables and if there is no specific ID from table 2 in table 1, i need to add that entire row (with all other cells ) to table1.
Don't want to use for loop, i wan't something with primary key
but not sure how to use it and how to compare this
Help me pleaseeeee
This post has been edited by miki8282: 08 July 2008 - 06:33 AM