SQL Combining 2 result sets in an ordered way -
Can someone order 2 questions in the same result set? More specifically, if I had 2 queries: select 'line', product, numerical_with numbered orders by product; Select 'Total', Product, Sum (numeric_free) from the numbered group by product; There is one way to combine two questions, so that the result set will look like this: Type product numeric_value line item 1 23 line item 1 57 Line items 1 23 total items 1 103 line items 5 20 line items 5 50 line items 560 total items 5 130 ... Basically, I'm looking at a list of all item records of a product, then show them an amount for them, Then the list of all item records of the next product, etc. Doing this Is there any way, or is this an impossible task? Thank you :) In many databases, you can do this with rollup However, since you have received it: from the select * (select the 'line', the product, numeric value of the numerical value) union all ('total', product, Choose the am...
