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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Query Master / Detail -Result Set and Output Both

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).

ProductMasterInfo
ProductDetailInfo
These 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?
Go to Top of Page
   

- Advertisement -