[Solved] find result in IN CLAUSE not in other table [closed]

by


Your where is wrong it must be a.id in not b.id in:

select a.id from t1 a Left out join t2 b on (A.id=b.id) Where b.id is NULL and a.id in (--100 records)

Because b.id can not be null and a value of your list

0

solved find result in IN CLAUSE not in other table [closed]