left join , Unknown column 't1.itemid' in 'on clause'
This is a discussion on left join , Unknown column 't1.itemid' in 'on clause' within the MySQL General forum forums, part of the MySQL category; --> Hi, select * from t1,t2 left join t3 on t3.itemid=t1.itemid mysql4.1 works, but mysql5.0 shows Unknown column 't1.itemid' in ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:08 AM
| ||||
| ||||
 left join , Unknown column 't1.itemid' in 'on clause' Hi, select * from t1,t2 left join t3 on t3.itemid=t1.itemid 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 mysql5.0 works ShumingˇˇWang      |
|
02-28-2008, 05:08 AM
| ||||
| ||||
| Re: left join , Unknown column 't1.itemid' in 'on clause' This is makes more sense because it causes a SQL developer to group the joined tables in a logical manner. ----- Original Message ----- From: wang shuming <wangshuming01@gmail.com> To: mysql@lists.mysql.com Sent: Friday, November 3, 2006 8:04:20 PM GMT-0500 US/Eastern Subject: left join , Unknown column 't1.itemid' in 'on clause' Hi, select * from t1,t2 left join t3 on t3.itemid=t1.itemid 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 mysql5.0 works Shuming　Wang |
Linear Mode
