W wupaul Unregistered / Unconfirmed GUEST, unregistred user! 2003-01-06 #1 我一个表中有两个字段PID和ID 现在我想用SQL找出ID不等于其它记录PID的记录,应该怎样写?
W watter Unregistered / Unconfirmed GUEST, unregistred user! 2003-01-06 #2 Select ID From Table where ID not Exists (Select Pid From Table)
H haiyang2008 Unregistered / Unconfirmed GUEST, unregistred user! 2003-01-06 #3 Select * From Table where ID not Exists (Select Pid From Table)
M maolu28 Unregistered / Unconfirmed GUEST, unregistred user! 2003-01-06 #6 select * from Table where ID not in (Select Distinct Pid From Table) good luck