Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
stixoffire
Starting Member
17 Posts |
Posted - 2008-05-23 : 04:37:14
|
I have a Query that Joins Master / Detail Data into one Result.I would like to output that result. (I know how to do this).ProductMasterInfoProductDetailInfoThese two are joined on a MasterID.. As One Result Set Lets Call It ProductView.I also would like to Query ProductDetailInfo against ProductView where the MasterID exists to get "AvailableStyles" as the ResultSet. I want to output both result sets.I want to avoid using the first query as a join in the second query - to avoid duplication of effort. In other words I am looking for an efficient way to get both results output - with out having to reissue the first query as a part of IN FIRST QUERY ..IS there any way I can store the first result - query against it with second query - and then output both result sets ?? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-23 : 04:59:09
|
Without some sample data from your tables, it would be very hard to suggest a way. Can you post them too please? |
 |
|
|
|
|