The excellent list function returns a string containing a comma-separated list composed of all the different values for string-expr in each group of rows.

e.g.

  SELECT customer_name, 
         List(department) dept_list
    FROM customers, departments
   WHERE customers.cust_code = departments.cust_code
GROUP BY customer_name;