Hi ,
Suppose i have two tables DEPT(DEPTID , DNAME) and EMP(EMPID,ENAME , DEPTID) and the two tables are joined by
DEPTID .
What is the query to get a result of the following type.
DEPTID EMPID
-----------------
10 1109
2234
2456
20 2321
2212
The DeptID should not be repeated in the Result(Group By)
How do i achive this..
Suppose i have two tables DEPT(DEPTID , DNAME) and EMP(EMPID,ENAME , DEPTID) and the two tables are joined by
DEPTID .
What is the query to get a result of the following type.
DEPTID EMPID
-----------------
10 1109
2234
2456
20 2321
2212
The DeptID should not be repeated in the Result(Group By)
How do i achive this..