By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,102 Members | 967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,102 IT Pros & Developers. It's quick & easy.

Two Tables

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Galsaba wrote:
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.


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...

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.