Compare 2 tables

[alwinSCH]

Hi, I have 2 Tables with each his own columns but they have both 1 identical column I want to make a 3th table with the identical columns in but not twice the same! For example: Table 1: ID1,Title,pages Table 2: ID2,Title,Author Table 3: ID3,Title (but when my title is the same in table1 and table2 i only want to insert it once) So i thought, I insert whole table1 in table3 then with a cursor, run through table2 and if i don't find the value in table3 insert Title from table2 in Table3 Is there another work around? Thanks, A.

[pmarfleet]

Are the IDs in tables 1 & 2 the same? If not, what value will you insert into column ID3 in table 3 when you find matching rows?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[Chetan Patel]

Insert into table3 (ID3,Title,xxx) Select ID1,Title,pages from Table1 Union (Select ID1,Title,author from Table2 Where Title Not In (Select Distinct Title From Table1))

Best Regards, Chetan Patel

[alwinSCH]

Thank You, I was looking way to far, for a solution...