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.
 
Back
Top