How to select record from one table if not present in another

[Seabz420]

I have 2 tables. One with member info (called A) and the other with card info (called B). How do I go about selecting all the members from table A that don't exist in table B? I'm not familiar with left outer joins and someone mentioned that that might work. Please help!

Evan

 

[synapsevampire]

Join the tables on the appropriate field (perhaps memberid?), and then in the record selection formula (report->Edit Selection Formula->Record) place something like:

isnull(tableb.memberid})

-k

 

[Turkbear]

Hi,
Just a note: In the Visual Linking Expert, be sure that tableA is the 'driving' table ( the leftmost one)..
That way a equijoin ( the default) will be fine..

 

[lbass]

I really don't think this will work without a left join. Create the link from TableA to TableB, then right click on the link->options and choose left join. Then use the following for your record select:

isnull({TableB.memberID})

-LB

 

[synapsevampire]

Ahhh, good point, LB, forgot to mention that it requires a LO Join.

-k