-
Combine columns from two select statements to one output table (join not possible!)
Combine columns from two select statements to one table
1. statement
Select Sum (Brutto) as B1, Sum (Netto) as N1
FROM Table 1
where ORDER_DATE between '19.09.11' and '19.12.11'
2. statement
Select Sum (Brutto) as B2, Sum (Netto) as N2
FROM Table 1
where ORDER_DATE > trunc(add_months(sysdate,-3))
Example for output statement 1
B1 N1
1658,89 1522,12
Example output statement 2
B2 N2
3256,45 2358,56
Question: how to combine both statements into one output?
B1 N1 B2 N2
1658,89 1522,12 3256,45 2358,56
Note: the two resulting tables do not have a column in common; thus one cannot use use a join - correct?
Thanks for your help!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|