Oracle SQL combine output from two queries into single output

Question

I am not able to create tables, but I want to combine the output from two queries into a single output. What I currently have

Output 1:

Date    Promo   Count
1-Aug   PROMO1  8
1-Aug   PROMO2  3
2-Aug   PROMO1  3
2-Aug   PROMO2  4

Output 2:

Date    Promo                 Count
1-Aug   DIFFERENTKINDOFPROMO1   3
2-Aug   DIFFERENTKINDOFPROMO1   5

What I'm trying to get (combine Output 1 and 2)

    Date    Promo   Count

    1-Aug   PROMO1  8
    1-Aug   PROMO2  3
    1-Aug   DIFFERENTKINDOFPROMO1   3
    2-Aug   PROMO1  3
    2-Aug   PROMO2  4
    2-Aug   DIFFERENTKINDOFPROMO1   5

As mentioned, I don't have the ability to create any tables, so I'm trying to do this on the fly so I get the final combined output.

Jon Roberts · Accepted Answer · 2016-08-10 21:04:12Z

2

select * from table1
union all
select * from table2;

answered Aug 10, 2016 at 21:04

Jon Roberts

2,1061 gold badge12 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

eckes Over a year ago

and if you need it sorted SELECT * FROM(SELECT ... UNION..) ORDER BY 1

Unoembre Over a year ago

You don't even need the subquery. Just put ORDER BY 1 at the end of the answer query (moving the ;).

Amit · Accepted Answer · 2016-08-10 21:58:45Z

0

As mentioned above this would be the final query.. select * from table1 union all select * from table2 order by 1;

answered Aug 10, 2016 at 21:58

Amit

1453 silver badges13 bronze badges

Comments

Gordon Linoff · Accepted Answer · 2016-08-10 22:01:05Z

0

If the ordering matters, then this needs a bit of care:

select date, promo, count
from ((select date, promo, count, 1 as which from table1
      ) union all
      (select date, promo, count, 2 as which from table2
      )
     ) t
order by date, which;

It is not possible to guarantee the original ordering within each table (because there doesn't seem to be an ordering key for each table), but you can be sure that table 2 records follow table 1 on any given day.

answered Aug 10, 2016 at 22:01

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

Oracle SQL combine output from two queries into single output

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related