Hi,
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 : http://www.du.se/~mho : screaming to find out
S-781 88 Borlange : Tel : +46 23-778120 : you were'nt asleep...
SWEDEN : Fax : +46 23-778050 :
-------------------+------------------------------+----------------------------
