Coping with duplicate values in a join table.

[nuct]

Hi,

I have the following three tables joined as follows, '>' indicates the join:

Students > Join table < Courses

Unfortunatly the middle table has duplicate records which are causing a query that im doing to count the number of students on a particular course incorrectly.

I can not remove the duplicate values yet so i will have to work with them.

I have tried to use DISTINCT in a view but to no avail.

Are there any other ways to deal with it?

Cheers in advance,

Simon

 

[carp]

DISTINCT should do it:

SELECT DISTINCT students_info, course_info
FROM join_table;