RE: Join syntax problem

2010-04-27 Thread Steven Staples
esigns.com] > Sent: April 26, 2010 10:29 PM > To: mysql@lists.mysql.com > Subject: Re: Join syntax problem > > Thanks for the replies. It was my understanding that whitespace is > ignored, > and I did not think that not having space, in particular with "." wou

Re: Join syntax problem

2010-04-26 Thread Gary
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"" wrote in message news:20100426233621.10789.qm...@lists.mysql.com... I cant seem to get this working.

Re: Join syntax problem

2010-04-26 Thread Rob Wultsch
I am reading this on a tiny screen but it looks like you need whitespace before the where. On 4/26/10, Gary 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.ameri

Re: Join syntax problem

2010-04-26 Thread Tom Worster
On 4/26/10 7:36 PM, "Gary" 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 A