We have a VERY old Sqlite database that can NOT be resigned/changed at this late stage.
It has fields like User1, User2, and ConversationDate.
How would I use "GROUP BY" so that instead of 2 records output... I would only get 1?
Bad output:
Bob contacted Fred on 01-Jan-2007.
Fred replied to Bob on 11-Jan-2007.
Desired output:
Bob and Fred resolved this issue on 11-Jan-2007.
The order of the names would appear as it did in the OLDER record (01-Jan-2007) "Bob and Fred", not "Fred and Bob".
The "resolved date" is the newer of the 2 dates (11-Jan-2007).
(Some of the 'conversations' had 2,3,4,5 records... not just 2.)
PS: How do customers kept coming up with these odd requests????