Left Join

P

Phil

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
 
A

Allen Browne

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

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