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