select * from Table1left join (select Id from Table2) T2on Table1.Id=T2.Idwhere T2.Id is null
not exist
不是，WHERE是筛选条件，查询还是在from的内容里
