| Author: Yugi 01 Dec 2008 | Member Level: Gold | Rating:  Points: 3 |
Good Morning yar
Here you didn't mentioned second table stucture. However use inner join for this.
like:
select tabname1.*,tabname2.* from tabname1
innner join tabname2 on tabname1.primarykey_field= tabname2.primarykey_field
|
| Author: divya 01 Dec 2008 | Member Level: Gold | Rating: Points: 2 |
Hi
Try this
select t1.empid,t1.ename,t2.ename as mngrname from emp t1 inner join emp t2 on t1.empid=t2.mngrid
|
| Author: greeny_1984 01 Dec 2008 | Member Level: Diamond | Rating: Points: 1 |
select a.empid,a.ename,b.managername from table1 a ,table2 b where empid=mangerid
Regards,
Greeny_1984
Rate this Response[Excellent/Good/Poor]
FRESHERS check this link
Need help from me join here
|