Jump to content

Archived

This topic is now archived and is closed to further replies.

leemar99

Doulble Feilds

Recommended Posts

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

Share this post


Link to post
Share on other sites
Well, sure, you could just add a GROUP BY clause, but you should probably get to the root of the problem.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.