hello
I am looking for an efficient query which will display a report having following columns
Dept | Employee id
(Field to join is DEPT_ID)
Where Departments are stored in DEPT table and list of employees is stored in EMP table. What I want is a join between 2 table but display just one employee (any random) for each department.
At the moment if I fire inner join it displays all employees from EMP table.
Abhijeet