SQL Group by clause error

[M. H. K.]

Using this SQL; 

Select MAX(RecordedTime) as T,SessionID,mediaTitle,recID FROM
SubscribeActivity where date='10/16/2002' GROUP BY SessionID

I am getting this ERR;

Microsoft OLE DB Provider for SQL Server error '80040e14' 

Column 'SubscribeActivity.mediaTitle' is invalid in the select list
because it is not contained in either an aggregate function or the GROUP
BY clause.

In my table, "mediaTitle" and "recID" are valid field names. However only
when I took them out from the above SQL, I am getting no error. But I do
want to list their values. So what to do ?


---
You are currently subscribed to activeserverpages as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]