Subject SQL Help please: Group by with a text blob
Author OB1
I've been using a normal select with no joins, then I needed to pull in
another value MAX(.....). The problem is that I'm selecting a text blob
which cannot go in the 'Group by', Is there a way to rewrite the SQL below
so that I can still pull in the MAX col and also the Text blob?

SELECT t.TASK_ID, t.TITLE, t.DESCRIPTION <lots of other t. fields here>
, MAX(th.change_id) as LastViewChangeID
from TASKS t
left outer join TASKS_HISTORY th
on t.TASK_ID = th.TASK_ID and th.CHANGE_TYPE = 'V' and
group by t.TASK_ID, t.TITLE, t.DESCRIPTION <other t. fields>

[Non-text portions of this message have been removed]