Jump to content


Photo

Doulble Feilds


  • Please log in to reply
1 reply to this topic

#1 leemar99

leemar99
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 11 September 2006 - 09:13 AM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 11 September 2006 - 02:08 PM

Well, sure, you could just add a GROUP BY clause, but you should probably get to the root of the problem.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users