I have this SQL Query:

 SELECT club . * , MAX( story.stid ) , story.longheadline
FROM club, story
WHERE club.sid = story.siteid AND club.div = 'epl'
and club.test = 0
and story.synd = '1'
GROUP BY club.sid
ORDER BY club.clubname ASC

The problem is that its not displaying the 'story.longheadline' that 
correlates with the "MAX(story.stid)"

Any clues? I'm lost....

Cheers
John Wards

---------------------------------------------------------------------
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

Reply via email to