I have 2 sql statements below. I want to select distinct rows based on columns "recipient" and "email". The first sql statment works fine. However i now also want to include the field "dateopened", but dont want this to select distinct rows based on dateopened. i.e i want have the first SQl statement but also include field "dateopened"
How can i acheieve this?
Hope that makes sense,
1) "select distinct recipient, email from [Tracker]"
2) "select distinct recipient, email, dateopened from [Tracker]"