Another Join Statement please??? Help. 1

[qajussi]

Hi!

Trying to write a SQL statement to get the list of number of companies group by Country.

TblCountry
CountryID
CountryName

TblCompany
CompanyID
CountryID
CompanyName

I want to get a table with

CountryName Number of Company


I got this far,
SELECT TblCompany.CountryID, Count(TblCompany.CompanyID)
FROM TblCompany group by CountryID

which gives me the
CountryID number of company.


Can you help??
Thanks millions.

 

[PHV]

SELECT B.CountryName, Count(A.CompanyID)
FROM TblCompany A INNER JOIN TblCountry B ON A.CountryID = B.CountryID
GROUP BY B.CountryName

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[qajussi]

Thank you very much PHV.
It looks so simple when you have done it.

Qajussi