G
Guest
I'm having an issue where performing an outer join between two linked ODBC
tables performs exactly the same as an inner join. I read a MS KB article
that explained that the where clause was evaluated at different times for
ODBC queries than for normal access queries. There was a link to the JET
engine update for version 3.51. However, I have Access 2003 SP2 and my JET
version is 4.00+.
Is this a known problem? Is their a fix? Or do I just have do something
like this (untested, but I think I did something like this in a college class
once and had it work):
SELECT *
FROM a,b
WHERE a.col1 = b.col1 or b.col1 IS NULL
tables performs exactly the same as an inner join. I read a MS KB article
that explained that the where clause was evaluated at different times for
ODBC queries than for normal access queries. There was a link to the JET
engine update for version 3.51. However, I have Access 2003 SP2 and my JET
version is 4.00+.
Is this a known problem? Is their a fix? Or do I just have do something
like this (untested, but I think I did something like this in a college class
once and had it work):
SELECT *
FROM a,b
WHERE a.col1 = b.col1 or b.col1 IS NULL