combining subquery results 1

[amy88]

I am writing a query and want to combine two subqueries in an unusual way.

Is there any way to combine the contents of subqueries and so that you have the complete data sets from each subqry in independent rows... add the rows from subqry 2 to subqry 1 (rather than adding columns from subqry 2 to subqry 1).

This is driving me crazy. Really appreciate any advice.

 

[gmmastros]

It's hard to say without seeing your code, but I would encourage you to do a little research on the "Union" and "Union All" operators.

Union will filter out distinct rows so it is a little slower than Union All that does not filter out distinct rows.



-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[amy88]

Thanks... will check into it immediately and post what I find out.

 

[amy88]

Awesome, simple for you, but I never used it. UNION ALL was exactly what I needed!!!