Thanks Johnatan. After I put tables in brackets - everything worked fine! ;)
And thank to everybody else. -afan > 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]
