Doulble Feilds

[leemar99]

Im trying to pull information from a Adobe Breeze Database. The Breeze database keeps information on scores/feedback etc of e-learning courses that people have taken!

For some reason when a person completes a criculum it enters the information twice, 2 sets of scores, etc! So when i run my querie they results are doubled, not what i want!

Each person has a pricipal_id so if there anyway i can tell it to bring back 1 principal_id rather than both?

something where if the name is the same only display where pricipal_id different

Here is my querie so far -

SELECT *
FROM (dbo.PPS_SCOS JOIN dbo.PPS_TRANSCRIPTS ON dbo.PPS_SCOS.SCO_ID = dbo.PPS_TRANSCRIPTS.SCO_ID)
JOIN dbo.PPS_PRINCIPALS ON dbo.PPS_TRANSCRIPTS.PRINCIPAL_ID = dbo.PPS_PRINCIPALS.PRINCIPAL_ID
WHERE PPS_SCOS.NAME LIKE 'MT%'
AND PPS_TRANSCRIPTS.STATUS LIKE 'P'
AND PPS_PRINCIPALS.LOGIN LIKE '%banff-buchan.ac.uk'
ORDER BY PPS_SCOS.SCO_ID ASC

[fenway]

Well, sure, you could just add a GROUP BY clause, but you should probably get to the root of the problem.