I have not tried, but i think this is what he meant: FROM tn t INNER JOIN bill_info b ON (b.id_b = t.id_t) LEFT JOIN shipp_info sh ON (b.bill_id=sh.bill_id)
HTH, On 1/16/07, Chris White <[EMAIL PROTECTED]> wrote:
[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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
