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]
