I have two tables (master-detail):
Table 1: Department
Table 2: Employee
I want to make a query with two columns.
Column_1 : The Department
Column_2 : A combination (concatenation?) of all the employee's from the
For instance, this could be the result:
Sales : John, Paul, George, Ringo
Prod : Bill, Mick
Can anyone help me make this query?