Hi,
*Sample Data
*Company
=============
CoId CoName
1 Company1
2 Company2
3 Company3
**
Employee
============
EmpId EmpName
1 Employee1
2 Employee2
3 Employee3
4 Employee4
5 Employee5
**
Manager
=============
ManId Company Employee
1 1 1
2 1 2
3 1 3
4 2 4
5 2 5
**
I want Following Result
*
Company Manager
Company1 Employee1,Emplyee2,Employee3
Company2 Employee4,Employee5
*
I do not want to write a function and use any cursore for that is there any way that i could generate this result in a single query using joins and some syetem defined function? :confused:
*Vijay Soni
a2z Infotech Pvt. Ltd.
308, ACME Plaza, M.V. Road
Andheri (E), Mumbai-59
Telefax:(022) 550 21759/60
<mailto:vijay@a2zinc.net>
<http://www.a2zinc.net/>
"Web-based software for managing and marketing events"
*
on