Left Join

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have two tables that I have joined together using a left outer join, is it
possible to show in the Cell where there is no match on the join some
specific text.

Thanks
 
Use Nz() to supply the value to use for null, e.g.:

SELECT Nz(MyOuterTable.Field1, "Nuffin here") AS MyFudge ...
 
Back
Top