is this what you meant? select max(submit_number) from tAnswers Where user_id = XXX
cheers barry.b -----Original Message----- From: Knott, Brian [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 August 2003 4:10 PM To: CFAussie Mailing List Subject: [cfaussie] selecting the max ID If I have a table that contains answer, user_id and submit_number now do I retrieve the maximum submit numbers for each user. Brian Knott --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
