I have two database tables, one has company information and a company Key. In another I have a list of users for that company. I need to count the number of users within that company for each record.

I have a recordset that shows all the companies in my page but I also want to show the number of users for each company as well within the recordset.

I tried count, but I got all the users for every company.

I'm fairly new to MySQL...any ideas?