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

Left join problem

P: n/a
Here is the problem.

I have a table called Locations with a field called Location which
holds a list of peoples names.
I have a query (query1 say)which has two fields :-
1st field is a person's name
2nd field is a number.

I want a query (query2 say)to join the table and query1 with a left
join such that all the people listed in the locations table are shown
in the results along with the number from the 2nd field of query1 or
null if the person isn't in the 1st field of query1.

Simple you might think.
I got it to work in Access 2000 (at home) but not in Access 97 (at
work).
query1 is working correctly but (at work - Access 97) query2 just
results in the list of names from the location table and then null for
the numbers against EVERY name.

Does anybody know why this might be happening?
TIA

Chris.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SQL is exactly the same in both versions.
Any other ideas?

Chris.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.