Trying to create a query of a single table where unique values are based on 2 of the 4 fields. HOWEVER, result of the query needs to display all 4 fields. Example 4 fields are name, date, qty and amount. I want to display all 4 fields but only where name and date are unique.
"SELECT DISTINCT name, date FROM tablename " for the above example returns only name and date fields and I can not figure out how to include qty and amount