Sql Server Two Table Operation

How to list the rows of table A that are not in Table B?

Ans

Actually it is the inverse of inner join.

select * from A where A.ID not in( select A_ID from B)

here A.ID is primary key and A_ID is forgin key in table B.

here the operation summery...

Reference:http://www.dba-oracle.com/t_convert_set_to_join_sql_parameter.htm