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