Re: Joining two tables and counting one

[Chris Stubben]

Hi,

You can join two tables and use an aggregate function.


SELECT r.Region_name, COUNT(*) AS numrows
FROM Customers c, Regions r
WHERE c.Region=r.ID
GROUP BY r.Region_name


Also, be sure you have indexes on both columns joined in the WHERE clause.


Chris