SQL Server: combine two small Selects in one -
i using next nested selects part of larger query.
is there way can combine both of them in 1 don't have run 2 separate queries here ?
// ... r.requester, ( select a.email requesteremail logtable a.ntid = r.requester xml path(''), elements, type ), r.approver, ( select b.email approveremail logtable b b.ntid = r.approver xml path(''), elements, type ), // ...
many help this, tim.
select a.email requesteremail,b.email approveremail logtable b bring together logtable on b.ntid = r.approver , a.ntid = r.requester xml path(''), elements, type
sql sql-server select stored-procedures
No comments:
Post a Comment