select * from t1 left join t2 on t1.id=t2.id where t2.id is null
一般就這麼幾種方法Select * From t1 Where id Not In (Select Distinct id From t2)Select * From t1 Where Not Exists (Select id From t2 Where id = t1.id)Select t1.* From t1 Left Join t2 On t1.id = t2.id Where t2.id Is Null
--用left joinSelect t1.* From t1 Left Join t2 On t1.id = t2.id Where t2.id Is Null
From t1
Left Join t2 On t1.id = t2.id
Where t2.id Is Null