I have two tables, say TableA with col A and TableB with col B. I want to find all records in TableA , col A that are not in table B, col B.
I have coded this type of thing several times with clumsy constructs such as
SELECT colA from TableA where ColA not in
(select ** from TableA join Table B
ON TableA.colA = TableB.colB)
but would like a more "eloquent" t-sql way of doing this.