Thanks for the replies. It was my understanding that whitespace is ignored,
and I did not think that not having space, in particular with "." would
result in an error message.
Gary
""Gary"" <gp...@paulgdesigns.com> wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
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
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5063 (20100426) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
