Joining multiple queries with different requirements

[questhaven]

If I have 9 queries, six of which are looking for the same fields within the same 3 tables and three that only require information out of one of the 3 tables, and can not be joined with the remaining 2 tables, what would be the best way of going about this? Would I select everything into a temp table and use that for mining the data?

Thanks for any help!

- Michele

 

[questhaven]

I figured it out. In case anyone has this same question, what I did was alias the column names in the 6 queries that have extra data (only 2 columns each) and then in the 3 other queries I assigned dummy values to these alias names - then unioned all of the queries together in one stored procedure.

 

[andrewflagg]

You couldn't have said it better..


create stored procedure foo as

select t.(list of columns, , ,) from table t
UNION
select t.(list of columns, , ,) from table t
UNION

etc...

andy

 

[questhaven]

Actually Andy - I think the way I said it is just fine...but thanks for your further clarification.