SQL query: Get correspondence descriptions instead foreign key IDs. Is that possible ?

[sdancer75]

Hi, I have 4 tables in a cascading mode like this : 1)Countries --> 2)Chapionships --> 3) Teams --> 4) Coupons Coupons table has 2 IDs (HomeTeamID and HostTeamID) that points to the Teams table. It has also IDs for the tables (Countries and Chapionships) All I want is to select the appropriate records from the Coupons Table, but instead of the foreing keys IDs I want the correspondence descriptions that these keys shows from their tables (ie Countries, Chapionships and Teams). Is that possible ? All I did until now is the query SELECT * FROM Coupons LEFT JOIN (Countries, Chapionships, Teams) ON (Countries.CountryID=Coupons.CountryID AND Chapionships.ChapionshipID=Coupons.ChapionshipID AND ( Teams.TeamID=Coupons.HomeTeamID OR Teams.TeamID=Coupons.HostTeamID)) Where Date='2009-07-31' order by Time Asc; but I get double rows for each record since there is an OR clause inside the ON. Any better solution ? Regards

sdancer75

[Blue_Boy]

Use distinct or try to group.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com