A little help with a query :)

Results 1 to 2 of 2

Thread: A little help with a query :)

  1. #1
    Join Date
    Dec 1969

    Default A little help with a query :)

    I have a database where people go in and enter responsibilities -- so there&#039;s a few tables.. USS (the employees and their ID numbers) ROLES (the roles and the role&#039;s ID number, linked with the employee ID) and RESPONSIBILITIES, the table that holds entries from the user.. It holds their employee id and the role ID....<BR><BR>Anyway, I&#039;m wanting to run a query that will display the name of the responsibility and the number of people that have chosen it as a responsibility.. Any help is appreciated. I just don&#039;t know how to structure the SQL statement...<BR><BR>dep<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: A little help with a query :)

    SELECT resp.Description, count(resp.employeeID<BR>) AS EmployeeCount<BR>FROM RESPONSIBILITIES resp<BR>GROUP BY resp.Description<BR><BR>That should work?<BR><BR>-Doug<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts