Need query
table1:
eno ename
1 madhan
2 kumar
3 wills
4 kou
table2:
eno1 eno2
1 2
3 4
Output:
eno1 ename eno2 ename
1 madhan 2 kumar
3 wills 4 kou
I need a query for getting this output. I tried with using one more instance of table1. It works fine. But i want to know is there any other way.