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 ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A bug in GUI of creating query with more outer joins between two tables 5
Apply condition on Outer join table, Not at WHERE Statement 1
Relationship - Outer Join - Microsoft Access 2002 1
Multiple join types in one query, jet compatible, exec from Excel/ 3
left outer join 2
Forcing an ambiguous outer join 5
Full Outer Join Question 3
upc and pos 3

Back
Top