2006/2/20, Eric Persson <[EMAIL PROTECTED]>: > Hi, > > I have a query which works fine for me in my 4.1 environment, but when > moved to the 5.0.18 environment, it fails with the result below: > > mysql> SELECT r.uid, u.username, u.image_type, count(id) AS antal, > s.timestamp FROM recruits_uid r, users u, users u2 LEFT JOIN sessions s > ON s.uid=u.uid WHERE r.uid=u.uid AND r.rec_uid=u2.uid AND u2.deleted="0" > AND datetime>"0000-00-00 00:00:00" GROUP BY r.uid ORDER BY antal DESC > LIMIT 100; > ERROR 1054 (42S22): Unknown column 'u.uid' in 'on clause' > mysql> > > It seems like the table alias u is not recognized for some reason. Does > anyone have any hints about this? >
http://dev.mysql.com/doc/refman/5.0/en/news-5-0-12.html precedence of comma has been change to conform to standards. So you'll have to use arenthesis or rewrite your query. -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]