Re: Strange error in query with joins and subquery

2005-10-18 Thread SGreen
(response interspersed) Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote on 10/17/2005 07:49:36 PM: > Just recently (possibly since upgrading to MySQL 5.0.13 RC), I've been > getting the following error with queries like the one below. > > Unknown column 'photos.id' in 'on clause' (1054) > > SEL

Strange error in query with joins and subquery

2005-10-17 Thread Jasper Bryant-Greene
Just recently (possibly since upgrading to MySQL 5.0.13 RC), I've been getting the following error with queries like the one below. Unknown column 'photos.id' in 'on clause' (1054) SELECT photos.* FROM photos LEFT JOIN tags_photos ON tags_photos.photo = photos.id WHERE 1 AND tags_photos.tag IN