Chip, > I have a database with 12 tables. I am running a query to select certain > fields > from 3 of the tables, like this - > > select Title, Details, StartDate, City, State > from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations > where phpCalendar_Details.EventLocationID = >phpCalendar_EventLocations.EventLocationID > group by City; > > The problem is the StartDate field data for the first returned row is carried down >through > all the rows, rather than picking up the correct StartDate data. All the other data >is > picked up correctly. When I change group by to State or Title or any field, I get >the same > problem, whatever the first returned field, it is carried down through all the rows. >How do I > get around this, or what am I doing wrong?
>From this can we assume (you don't give table schema) that StartDate is in the >phpCalendar_Daily table and is the only field selected from that table? Take a look at the WHERE clause: the query is using three tables but only joins two. Is that it? =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
