Hi,
I am trying to remove duplicates from this query, but I need to have the unique identifier column, ID in the query, so the DISTINCT fuction is not working because, the columns that have dupes have unique IDs.
SELECT DISTINCT Course, coursename, ID
FROM t_courses
WHERE (Course = 28447)
The courses with this course number are all showing up, because I can't get rid of the ID column in the query.
Any ideas how to return all three columns with the Distinct working off the course field?
Thanks
I am trying to remove duplicates from this query, but I need to have the unique identifier column, ID in the query, so the DISTINCT fuction is not working because, the columns that have dupes have unique IDs.
SELECT DISTINCT Course, coursename, ID
FROM t_courses
WHERE (Course = 28447)
The courses with this course number are all showing up, because I can't get rid of the ID column in the query.
Any ideas how to return all three columns with the Distinct working off the course field?
Thanks