How can I make a query from to tables that will take data from both tables, and
will put zero in fields were there is no match between the tables.
will put zero in fields were there is no match between the tables.
-
-
Re: Two Tables
Galsaba wrote:[color=blue]
> How can I make a query from to tables that will take data from both[/color]
tables, and[color=blue]
> will put zero in fields were there is no match between the tables.[/color]
AFAIK, it depends on what key fields you're matching on. If there is
no match between records in table A and records in table B, then that
record (on the left side of the join) will have nulls on the right
side.
You could base a query on that query and then use NZ to convert them to
zeroes...
Comment