result of 2sqlstts joined by query...varchar?! [message #19451] |
Tue, 19 March 2002 06:34 |
chandra
Messages: 31 Registered: October 2000
|
Member |
|
|
Follow up of "querying tables and result of 2sqlstts joined by query"
I would like to obtain the result on one row eg.
PersonId, SalesMgrName, PurMgrName grouping by Person id. I know this can be done using group functions but I need characters(name) here!!
Select person_id...from
(select person_id, SalesMgrName Name from Sales
union all
select person_id, PurMgrName Name from purchases)
group by person_id)
Any help would be appreciated!!!
|
|
|
Re: result of 2sqlstts joined by query...varchar?! [message #19452 is a reply to message #19451] |
Tue, 19 March 2002 08:43 |
sri
Messages: 154 Registered: February 2000
|
Senior Member |
|
|
Try this,
SELECT Distinct v.PersonId, s.SalesMgrName, p.PurMgrName
FROM
(Select distinct Person_id from Sales
union
Select distinct Person_id from purchases) v,
Sales s, purchases p
WHERE s.PersonId = v.PersonId
AND p.PersonId = v.PersonId
and s.PersonId = p.PersonId
regards,
Sri
|
|
|