inserting 0's into nulls

Joined
Nov 18, 2005
Messages
1
Reaction score
0
I have a query where certain values are blanks because of a left join. How would I fill up those blanks with 0's? Here is my code.

SELECT DISTINCT MainInput.[5100/5300], MainInput.Type, MainInput.CountOfSerial_Number, RadioOutPut.CountOfSerial_Number
FROM MainInput LEFT JOIN RadioOutPut ON (MainInput.Type = RadioOutPut.Type) AND (MainInput.[5100/5300] = RadioOutPut.[5100/5300]);
 

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

Back
Top