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

Need SQL help

P: n/a
I have two tables. The first, BudgetPlan, has FundCode and PlanAmount and
the second, BudgetActual, has FundCode and ActualAmount. In the beginning
of the year the BudgetPlan has its FundCodes populated with planned amounts
and over the course of the year as money is spent, records are added to
BudgetActual.

When I do query to join the two tables, it only shows records where there
are matching FundCode records in both tables. I want a query that returns
results like this:

BudgetPlan BudgetActual
FundCode Amount Amount
AAA 100 89
BBB 50 0
CCC 78 78

For FundCode BBB BudgetPlan has an Amount of 50 and there is no
corresponding FundCode entry in BudgetActual.

The only way I can get this to work is to create a record in BudgetActual
with no value in Amount.

I have tried setting the Access joins in the Query Builder all three ways
but it just won't do it.

What am I doing wrong?
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.