Testing if a record exists in another table [Resolved]

[olamm2k]

Yes, a LEFT or RIGHT OUTER JOIN can be used.
Something like this:

"SELECT Surname & Chr(44) & Chr(32) & Forenames AS FullName,
IIF(IsNull(RegMem.MemID), "N", "Y") AS Present
FROM Members
LEFT JOIN RegMem
 ON Members.MemID = RegMem.MemID
WHERE SDate = #" & Format(dteSDate, "yyyy-mm-dd") & "#;"

I'm assuming that you are using Access...

LEFT JOIN is the one that selects everything from the first table and just the records from the second table with the matching field specified, right?

What's the difference between an INNER and OUTER JOIN?

I am using access. I didn't know you could use functions like IIF and IsNull in statements like that. I'll give it a try - thanks.