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 -
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
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users