> ? I see several issues in the change logs regarding left joins
> but I do believe they were available for 3.22.32.
> I use 3.22.32 on WinNT. Left Join works perfectly (I have one stmt that has
> 10 left joins).
Yes, it does work!
Actually it was the INNER JOIN that got me on the wrong track:
SELECT * FROM T1 INNER JOIN T2 ON T1.ID = T2.ID
-> You have an error in your SQL syntax near 'ON T1.ID = T2.ID'
so I figured that the JOIN syntax is not supported on this version
and used for inner joins:
SELECT * FROM T1, T2 ON T1.ID = T2.ID
now I tested the left join:
SELECT * FROM T1 LEFT JOIN T2 ON T1.ID = T2.ID
and it works perfectly, sometimes we don't see the obvious...
thanks all for getting me back on track!
Holger
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
