Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Left join fails in SQLyog Enterprise 4.01
I don't believe it's an issue with sqlyog …
The error-message looks like it's is generated by MySQL itself.
You could try running the query from “MySQL Query Generator” (download from http://www.mysql.com) and you will probably have the samme error message.
BTW – do you use INNODB tables ?