LEFT JOIN NOT WORKING?

[rmuller]

Hi,

Since a couple of days i am working with AccessXP and i am getting sadder every day..

Even some very simple queries do not work:
Table tmp has 1 column 'id' with 28 rows
Table H has also a column 'id' and 1778 rows.
Now i want to join these tables with a VERY SIMPLE query:

SELECT <fields> FROM
tmp LEFT JOIN H ON tmp.id=H.id;

This gives 1778 records (so performs a INNER JOIN).

I have installed the Jet 4.0 SP5 (because this problem was known by Microsoft, see Q275058).

So: Is Access still broken or am i missing something??

Hope someone can help me (and i never need Access in the future..)

Ronald

 

[Aivars]

Hi Ronald!

Do like me always do: use access query wizard - create needed query, then open SQL window (press button left on top) then simple copy SQL text and paste into VBA code if it's needed.

Aivars

 

[jhall156]

not an inner join I don't think but a full outer join. Maybe it now requires the keyword outer. Boy that would be bad. And not be ANSI compliant. And you say they shipped it knowing it did this? Cheese and rice!