I am reading this on a tiny screen but it looks like you need whitespace before the where.
On 4/26/10, Gary <gp...@paulgdesigns.com> wrote: > I cant seem to get this working. > > $query="SELECT im.image_id, im.caption, im.where_taken, im.description, > im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american, > kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter" . > "FROM *images AS im"."JOIN keywords AS kw USING (image_id)" . > "WHERE ky.image_id = im.image_id"; > > Gets me this error message. > > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near 'keywords AS kw > USING (image_id)WHERE ky.image_id = im.image_id' at line 1 > > Anyone see where I am going wrong? > > Thank you. > > Gary > > > > __________ Information from ESET Smart Security, version of virus signature > database 5063 (20100426) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=wult...@gmail.com > > -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org