>- see footer for list info -< Hi guys, I have one table called DEPARTMENTS (uid,name) and one called EMPLOYEES(uid,emp_name,department_ID).
The EMPLOYEES table contains department_id so we know which department the employee belongs to. How do I write a SQL query to get all department names, but include in that resultset the number of employees within each deartment. So for exampe: 1. Housing (4 Employees) 2. Catering (10 Employees) 3. Drinks (2 Employees) Etc... thanks, Damien _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
