# Thread: Combine columns from two select statements to one output table (join not possible!)

1. Junior Member
Join Date
Dec 2012
Posts
3

## 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

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?

2. Junior Member
Join Date
Dec 2012
Posts
3
Possible Solution

Select t1.B1, t1.N1, t2.B2, t2.N2
From
(Select Sum (Brutto) as B1, Sum (Netto) as N1
FROM Table 1
where ORDER_DATE between '19.09.11' and '19.12.11') t1
,
(Select Sum (Brutto) as B2, Sum (Netto) as N2
FROM Table 1

3. If you are trying to get the rows from both tables,
but the data is different then you want a union all.

Code:
```select *
from ( select sum (brutto) as b1, sum (netto) as n1
from table 1
where order_date between '19.09.11' and '19.12.11'
union all
select sum (brutto) as b2, sum (netto) as n2
from table 1
order by 1;```

4. Junior Member
Join Date
Dec 2012
Posts
3

## different visualisation

Thanks for the response.

Note: the main difference between simply using a comma (1) or union all (2) is visualisation of the resulting table, i.e.

(1) present all four columns from the two resultnig tables side by side (= resulting table with 4 columns and 1 row), while

(2) presents results from one table in one column and results from the second result table in a second column (= resulting table with two columns and two rows).

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts