I am not a SQL Guru so there might be something more effecient but it seems something like this would work:
p1.LastName + ', ' + p1.FirstName as Buyer,
p2.LastName + ', ' + p2.FirstName as Agent,
p3.LastName + ', ' + p3.FirstName as Seller
FROM offer o
LEFT JOIN Person p1 on p1.PersonID = o.BuyerID
LEFT JOIN Person p2 on p2.PersonID = o.AgentID
LEFT JOIN Person p3 on p3.PersonID = o.SellerID
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click
on their post!
"Easy is the path to wisdom for those not blinded by themselves."