|
|
I'm trying to use a DISTINCT in my SQL statement on an ID string. This works well, but when I add a date string, called DateEmailSent, the DISTINCT ID does not work. Can someone help me or explain why this cannot work? The bold in the SQL statement below is what I added.
Thanks for your time!
< -- SQL Statement -- >
SELECT DISTINCT SupportID, ID, Email, SerialNumber, DateEmailSent
FROM support_thread WHERE Status = 'Receive' OR Status = 'View'
GROUP BY DateEmailSent, SupportID, ID, Email, SerialNumber"
< -- End of SQL Statement -- >
|
|
|
|
|
|
|
|
jimmytieu