SQL Multiple Lookups from Join

TX2step

New Member
I have a query that looks something like this:\[code\]SELECT cu.CustomerCountryID, pr.ProviderCountryID, po.ProductCountryIDFROM tblCustomer cu INNER JOIN tblProvider pr ON cu.ProvID = pr.ProvID INNER JOIN tblProduct po ON pr.ProdID = po.ProdID \[/code\]There is then a fourth table that contains the name of the country. I want to replace the CountryID with the CountryName.I can't think right now how to do it without resulting to subqueriesCan anyone advise on a faster way to do this?Thanks
 
Top