10 Replies Latest reply on Sep 20, 2007 3:59 AM by Newsgroup_User

    SQL / Coldfusion display question

    Level 7
      I am not sure if this can be done in one SQL pull / Coldfusion display or
      not. If a table has an employee name and department, can you list the people
      using the department in the title and listing the people below it.


      Table: Employees

      employeeName department
      ---------------- -------------
      Steve Smith Admissions
      Susan Day Admissions
      Bob Turner HR
      Billy West HR
      Tom Jones Accounting

      And output this to a page:

      Steve Smith
      Susan Day

      Bob Turner
      Billy West

      Tom Jones

      Wally Kolcz
      Founder / Developer