Help with derived or sub SQL query

I have a rather large query with outer joins that based on what column you choose you get a different result.. The customer wants three different choices on one line.. You will have to see my attached example to understand what I want.. How can I take the three queries and match them by account number to get the three different columns on one record per account number? See attached..
Example.xls
LVL 1
cheryl9063Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

puttsCommented:
SELECT A.ACCOUNTNUM,A.[...],B.[...],C.[...]
FROM
     (SELECT [...] FROM [....] OUTER JOIN [...]) A
INNER JOIN
     (SELECT [...] FROM [....] OUTER JOIN [...]) B ON A.ACCOUNTNUM = B.ACCOUNTNUM
INNER JOIN
     (SELECT [...] FROM [....] OUTER JOIN [...]) C ON A.ACCOUNTNUM = C.ACCOUNTNUM

Is that, basically, what you are looking for?


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jaan33Commented:
Do the three example query results exists in the same tables? If so, can Prev & Req values be group by type? If the answer is yes, then use a pivot

Otherwise Putts response will work
0
cheryl9063Author Commented:
Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.