Outer Join With Where Clause For Right-Hand Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

According to KB article #275058, I should be able to create a query with an
outer join between two tables, where I've specified criteria for the
right-hand table, and the results should show all of my left-hand table
records, and only values for right-hand table records that match the filter
criteria.

According to the article, before SP4, MSJet interpreted this as an inner
join. With SP4, it is supposedly fixed. Nevertheless, I've installed SP8, and
this is still a problem.

Any confirmation that this bug is fixed?

Thanks.

Danny S.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A bug in GUI of creating query with more outer joins between two tables 5
Outer Join Question - "join expression not supported" 1
Access: problem with outer join - "Join Expression not Supported" 1
Outer join not working 3
SQL PROGRAMMING - LEFT OUTER JOIN 1
Nested JOIN clauses - order of precedence (Access 2007) 2
Union query or Outer Joins do not create desired results 3
Query Designer and outer joins 1

Back
Top