各位大大：    小弟有事求教，比如说，我有下面两张tabel    table1:     table2: 希望得到如下结果，该如何做？ table3 Thank you very much! 發表人 - luowy651 於 2004/07/30 12:18:03

 Select * from (
  Select * from table1 union Select * From Table2)
Where code not in (Select code From table2) 

~~應無所住而生其心~~

引言:

 Select * from (
  Select * from table1 union Select * From Table2)
Where code not in (Select code From table2) 

~~應無所住而生其心~~

谢谢terrychen大大提供的思路,小弟非常受益！我又改了一下，如下： SELECT * FROM table1 WHERE (code NOT IN (SELECT code FROM table2))

luowy651 你好

Select * From Table1 a Left Join Table2 b 
  ON (a.Code=b.Code)
Where b.Code Is NULL 

_______________________________________ 深藍的魚，祝您好運..........連連