Hi,
i have 2 tables. 
table A:
ID - primary key
ID2 - primary key
name
address

table B:
ID - primary key
ID2 - primary key
name
address

i want to select from table A where for records that do not exist in table
B. 
any help is appreciated.

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...
create a sp from query output
Combine records to calculate