Left join fails in SQLyog Enterprise 4.01

[bfalling]

Using SQLyog Enterprise 4.01 downloaded 1/18/2005:

When I attempt this query:

select i.pays_en from ins_pays i left join mst_country m on i.pays_en=m.country_name;

I get the following error:

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select i.pays_en from ins_pays i left join mst_country m on i.pa

(0 ms taken)

However, an inner join works fine:

select i.pays_en from ins_pays i, mst_country m where i.pays_en=m.country_name;

Also, running the left join above on (gasp!) SQL-Front displays the rows just fine.

[peterlaursen]

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 ?

[Author]

Posts