MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:wang shuming Date:November 17 2006 2:02am
Subject:Re: left join , Unknown column 't1.itemid' in 'on clause'
View as plain text  
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 96 Longkouxi Road, Tianhe
Guangzhou,Guangdong,China
http://www.xtech.com.cn  http://www.87595959.com
Email: wangshuming@stripped
QQ:100200651 , MSN: wang_shuming@stripped
Tel:86-20-87595959,  86-755-61302424 ---2001,2002
Fax:86-20-61004435
Thread
left join , Unknown column 't1.itemid' in 'on clause'wang shuming4 Nov
  • Re: left join , Unknown column 't1.itemid' in 'on clause'Rolando Edwards5 Nov
Re: left join , Unknown column 't1.itemid' in 'on clause'wang shuming17 Nov