join left unmatched with in db

Question

is it possible to join two tables on a field and only pull in what is in the left table but not in the right, with in db, not static, join?  i see how to do it with multiple static join but i'm not seeing how to do this with indb join.

thanks

becki kain

BenMoss · Accepted Answer

I think a left outer join in SQL terms provides you with the inner records that join and the left records that don't.

So if you do a left outer join, in order to get solely the records that don't match you could take the r.keyfield and keep only the instances where that isnull.

I.e. the match didn't occur.

Ben

becki · Accepted Answer

yes, that worked as long as I put a indb filter for right hand column is null, matching this sql:

SELECT columns FROM TableA LEFT OUTER JOIN TableB ON A.columnName = B.columnName WHERE B.columnName IS NULL