List:MySQL ODBC« Previous MessageNext Message »
From:Magnus Hoglund Date:January 1 1970 12:00am
Subject:Problems with LEFT JOIN in Access...
View as plain text  

I have a very strange problem with LEFT JOIN in myODBC and Access...
It works perfectly on my machine, but when I send the mde-file containing
my Access-program to a couple of users they get strange results...

I'm running a SQL-statement like this...

SELECT tbl1.fld11, tbl1.fld12, tbl1.fld13, tbl2.fld21, tbl2.fld22,
tbl2.fld23, tbl3.fld31, tbl3.fld32, tbl3.fld33 from (tbl1 LEFT JOIN tbl2
ON tbl1.fld12 = tbl2.fld22) LEFT JOIN tbl3 ON tbl2.fld23 = tbl3.fld33
ORDER BY tbld1.fld11, tbl1.fld12;

When i run this on my computer the result is as expected. I get a join of
the tables where the fields in tbl2 is set to NULL where there is no
matching record for it... However, when run on one of the other computers
I almost ONLY get the records (from tbl1) which have no match in tbl2!
I write almost, because of almost 500 records in tbl2 i get approx 10!

I run mysql version 3.22.16a-gamma on Solaris (binary dist) and the latest
myODBC for Win95/98 (2.50.22)... My PC is running Windows 98 and I have
Visual Basic 6.0 installed (which have installed a different odbc-driver).
The other PC's are running Windows 95 and an updated odbc-driver and
myODBC 2.50.22...

Anyone having suggestions??

Regards Magnus 

Magnus Hoglund     : Email: mho@stripped             : Real stress is waking up
Dalarna University : URL  : : screaming to find out
S-781 88 Borlange  : Tel  : +46 23-778120         : you were'nt asleep...
SWEDEN             : Fax  : +46 23-778050         : 

Problems with LEFT JOIN in Access...Magnus Hoglund30 Apr
  • Problems with LEFT JOIN in Access...Michael Widenius2 May