Query to Show 0 if no match found

pr4t3ek · #1 06-30-2009, 07:30 PM

Hi,
I have the following SQL code:

I would like to know if there is a way to bring back a "0" if no matches are found for all the items in the "DOBTable" table.

Code:

SELECT DISTINCT Name, DOB
FROM NameTable INNER JOIN DOBTable ON DOBTable.Name = NameTable.Name

Chance2 · #2 06-30-2009, 07:44 PM

That depends on the version of SQL you are using, for example Access uses NZ(field, value if null). MS SQL uses IsNull(field, value if null), and Oracle uses NVL(field, value if null).

pr4t3ek · #3 07-01-2009, 12:11 AM

Access it is

Welcome to the Excel Forum

Forum Statistics