RE: query taht works on mysql4 but doesn't on mysql5?

[Jonathan Langevin]

View the documentation here:
http://dev.mysql.com/doc/refman/5.0/en/join.html

You could write your statement as

SELECT
        Field1, field2
FROM
        Table1
        LEFT JOIN Table2
        LEFT JOIN Table3

OR

SELECT
        Field1, field2
FROM
        (Table1, Table2)
        LEFT JOIN Table3

Etc etc...

But you cannot do:

SELECT
        Field1, field2
FROM
        Table1, Table2
        LEFT JOIN Table3

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 16, 2007 11:06 AM
To: Chris White
Cc: mysql@lists.mysql.com
Subject: Re: query taht works on mysql4 but doesn't on mysql5?

> [EMAIL PROTECTED] wrote:
>> FROM ".$tn.", bill_info as b
>> LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id
>
> That would be the usage of multiple from's combined with a left join.
> Unfortunately with mysql 5 you can't do this.  You're going to have to
> do bill_info as a left/right/inner join instead.
>
Could you please elaborate a little bit more, please?

Thanks.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]