469,958 Members | 1,947 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,958 developers. It's quick & easy.

Left join problem

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

Similar topics

13 posts views Thread by StealthBananaT | last post: by
reply views Thread by Marek Lewczuk | last post: by
5 posts views Thread by Marek Kotowski | last post: by
1 post views Thread by Quarco | last post: by
9 posts views Thread by shapper | last post: by
reply views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.