compare two tables select not matching coloum in table b

Hi,
Alternate approach is as follows:
select * from a where NOT EXISTs (select 1 from b WHERE b.Mobile = a.Mobile)

Do you know one thing regarding NOT IN clause of SQL Server..
NOT EXISTS clause is more  optimised one comaring to NOT IN operator...

For suppose there is NULL value in the Mobile column of table B, then NOT IN query results NO more records... where as NOT EXISTS will give you correct result

For the below sample data NOT IN query gives NO records where as NOT EXISTS query gives you correct result.. Check once
table ' a'
sno       id        name          mobile 
1        1001      shashi         8985500134
2        1002      raju            7896543211

Hi ani,

try this,


select * from table_a 
except
select * from table_b


Hope it helps you