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