467,181 Members | 1,074 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Access sql statement - left outer join with selection criteria onon table

I am trying to use an access sql statement in a module that does a left
outer join on one table - joined to a table that has a selection
criteria. The result is an inner join.

If I do this in two pieces using queries, it works correctly.

If I remove the criteria, it works correctly but of course gives me more
matches than I want.

Access 2003

Suggestions?

Bob
Nov 13 '05 #1
  • viewed: 2595
Share:
1 Reply
On Thu, 05 May 2005 15:24:42 -0500, Bob Alston wrote:
I am trying to use an access sql statement in a module that does a left
outer join on one table - joined to a table that has a selection criteria.
The result is an inner join.

If I do this in two pieces using queries, it works correctly.

If I remove the criteria, it works correctly but of course gives me more
matches than I want.

Access 2003

Suggestions?


Use 2 queries rather than 1, is the simple answer. Trying to do both the
filtering and the outer join in a single query will create a contradiction
between the filter and the outer join - as you've seen, the filter wins
(so the join becomes an inner join instead).
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephen Patten | last post: by
5 posts views Thread by jason.evans@minterellison.com | last post: by
4 posts views Thread by Anna Smith | last post: by
8 posts views Thread by gimme_this_gimme_that@yahoo.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.