SQL Stored Procedure

Here is a sample of the data as it stands in our Db now

PersonID = 1
EnrollmentID = 100,101
OUTCOmeID = 500,501
In a simple query this result is returned
Person ---->Enrollment--->OUTCOME
1 100 Null
1 101 500
1 101 501

Enrollment 1 per the users is the Accountable Person Enrollment
OutCome 500 per the users is the accountable Person Outcome

I need to be able to return just one record compared to 3 above with this result

Person--->Enrollment--->OutCome
1 100 500

Can anyone give a sample T-QSL for this. Appreciate any help.

This is a duplicate of

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5677

Cheers
Twan