Malki,
>which gives the error:
>ERROR 1054 (42S22): Unknown column 'depts.dept_code' in 'on clause'
See the JOINs page of the manual. As of 5.0.12, MySQL improved ISO SQL
compliance in query parsing; ambiguities due to comma join syntax became
errors. It's highly recommended to switch from com
Hi,
On Jan 28, 2008 5:31 AM, <[EMAIL PROTECTED]> wrote:
> We have just moved to a new machine where we are running MySQL 5.0.45. On
> the old machine we were running MySQL 4.0.15a.
> The following query worked in 4.0.15a but gives an error mesage in 5.0.45.
> We're pretty sure the problem is with
We have just moved to a new machine where we are running MySQL 5.0.45. On
the old machine we were running MySQL 4.0.15a.
The following query worked in 4.0.15a but gives an error mesage in 5.0.45.
We're pretty sure the problem is with the left join. Did anything change?
Here's the query:
select
