Eliminating rows where one column is duplicated 1

[rwise2112]

Hi,

I'm very new to SQL and have a problem that I can't figure out. I'm using the following SQL query and I need to eliminate records where Tracks.RecordingID is duplicated. It seems the DISTINCT command checks all the records in the row and will not help here.

SELECT Tracks.TrackTitle, Tracks.RecordingID
FROM Tracks
WHERE (Tracks.TrackTitle) Like "*" & [Track Name:] & "*"
ORDER BY Tracks.RecordingID;

Can anyone help?
Thanks in advance

 

[SonOfEmidec1100]

This is one way I can think of. By the way you have missing quotes round the string in the like evaluation.

SELECT max(Tracks.TrackTitle), Tracks.RecordingID
FROM Tracks
WHERE (Tracks.TrackTitle) Like "'*" & [Track Name:] & "*'"
GROUP BY Tracks.RecordingID
ORDER BY Tracks.RecordingID;

 

[rwise2112]

Thanks,

That did it, but only if I exclude the quotes you say I need. If I include them it returns 0 results.

 

[SonOfEmidec1100]

Sorry about the quotes, should have looked closer at the where clause.