As you can see the Date/Time is identical, but the Subject and RowID are different.
Can anyone see what im doing wrong or suggest a better way to do it?
max(smsreceived) as Date,
contacts.firstname as First,
contacts.lastname as Last,
activities.visiondescription as Subject,
FROM activities, contacts
AND activities.contactid = 'AAXA-TGZQY62301';