Left/Right Join not working for ODBC Linked Table?

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

Guest

Hi guys:

In Access 2003, when I retrive all records from one table by Left join with
another table, the same record sets are obtained by INNER JOIN the two
tables. One of the two tables in the query is ODBC-linked. It should give me
8019 rows of the left table, but only 1533 rows are in the result, just as
the inner join.

My question is: does the left/right (outer) join not work in Access?

Thanks,

JD
 
Left and Right Joins work in Access. Can you post the query that doesn't work
the way you expect it to?

It could be something as simple as you applying criteria against fields on the
right side of the join. If you do that without also accepting null values you
have essentially turned the Left Outer Join back into an Inner Join.
 
Back
Top