试试这个：select * from tblnm where col1 not in (select col2 from tblnm) union select * from tblnm where col2 not in (select col1 from tblnm) [#4123894@0 -ROLIA.NET 相约加拿大网上社区 之 枫下论坛 & 枫下部落, 枫下论坛主坛 ]
试试这个：select * from tblnm where col1 not in (select col2 from tblnm) union select * from tblnm where col2 not in (select col1 from tblnm)
by
grant
(创业难)
at
2007.12.16 11:57
(#4123894@0)
select * from tblnm where col1 not in (select col2 from tblnm)
union
select * from tblnm where col2 not in (select col1 from tblnm)