Re: left join , Unknown column 't1.itemid' in 'on clause'

[wang shuming]

Hi,
  select * from t1,t2
  left join t3 on t3.itemid=t1.itemid
  left join t4 on t4.f2=t1.f2

  mysql4.1 works, but mysql5.0 shows  Unknown column 't1.itemid' in 'on clause'

 If change into
  select * from t2,t1
  left join t3 on t3.itemid=t1.itemid
  left join t4 on t4.f2=t1.f2

   mysql4.1 works, but mysql5.0 shows  Unknown column 't1.f2' in 'on clause'

Shuming　Wang
Xtech　Company　limited
Room　29H,17/F,Plaza　2,　Tiancheng　Building,No　96　Longkouxi　Road,　Tianhe
Guangzhou,Guangdong,China
http://www.xtech.com.cn　　http://www.87595959.com
Email:[EMAIL PROTECTED]
QQ:100200651　,　MSN:[EMAIL PROTECTED]
Tel:86-20-87595959,  86-755-61302424 ---2001,2002
Fax:86-20-61004435