I have two tables Emp and Dept
Emp columns -- eno,ename,dno
Dept columns -- dno,dname

I would like to display Emp Information like this

eno ename dno
1 m 10
2 n
3 o
4 x 20
5 y
6 a 30
7 b
8 c

m, n and o has same dno. so I want to display the dno 10 only once
x, y -- dno 20
a, b and c -- dno 30
How can I display the records in the above format?

Thanks and Regards
Anand