RE: Query error in aggregate function

2002-01-21 Thread Jeff Beer
Just add t_subcat_id to a GROUP BY statement: CFQUERY NAME=q_mostrecent DATASOURCE=uspc SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID FROM t_msg GROUP BY t_mess, t_subcat_id /CFQUERY -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002

RE: Query error in aggregate function

2002-01-21 Thread Steve Oliver
You could either use the GROUP BY statement: SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID FROM t_msg GROUP BY t_mess, t_subcat_id or do a subquery: SELECT t_subcat_ID, (SELECT MAX(t_mess) FROM t_msg) AS RECHIGH FROM t_msg __ steve oliver cresco technologies, inc.

RE: Query error in aggregate function

2002-01-21 Thread Mark Leder
9, 4, 1 So, if 85 were the most recent record, I would want 85 and 4. Thanks for your assistance. Mark -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 8:54 AM To: CF-Talk Subject: RE: Query error in aggregate function You could either use

RE: Query error in aggregate function

2002-01-21 Thread Pascal Peters
SELECT t_mess, t_subcat_ID FROM t_msg WHERE t_mess IN (SELECT MAX(t_mess) FROM t_msg) -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED]] Sent: maandag 21 januari 2002 15:56 To: CF-Talk Subject: RE: Query error in aggregate function I still have been unable to get

RE: Query error in aggregate function

2002-01-21 Thread Mark Leder
That worked - thanks. Mark -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 10:12 AM To: CF-Talk Subject: RE: Query error in aggregate function SELECT t_mess, t_subcat_ID FROM t_msg WHERE t_mess IN (SELECT MAX(t_mess) FROM t_msg