M
Martin
I hope I am explaining this correctly, so here goes
I have a query that is joining two tables. I want all records from my
"primary" table, and data from the second table if the key matches the first
table. (If I am following, that is a Left Join.)
My problem is that the numeric values from the second table that do not
match the first show in the query results as blank/null. Is there a way to
set up the query to display these blanks as zeroes?
KEY FIRSTTABLEDATA SECONDTABLEDATA
1 10 2000
2 100
3 200 5000
What I would like is to see a 0 on line two in the right column.
Thanks.
I have a query that is joining two tables. I want all records from my
"primary" table, and data from the second table if the key matches the first
table. (If I am following, that is a Left Join.)
My problem is that the numeric values from the second table that do not
match the first show in the query results as blank/null. Is there a way to
set up the query to display these blanks as zeroes?
KEY FIRSTTABLEDATA SECONDTABLEDATA
1 10 2000
2 100
3 200 5000
What I would like is to see a 0 on line two in the right column.
Thanks.