MySQL Merging two columns

Question

I am having a problem merging two columns from separate tables into one column. Here's the scenario, I have 2 tables each with different columns containing dates. I want to create a temporary table containing a column of all the dates from both original tables.

This is how I want it to turn out:

   Table: Table A
         ----------
Column: DateServiced
        2017-01-01 (1)
        2017-05-01 (2)

   Table: Table B
         ----------
Column: DateShipped
        2017-03-01 (3)
        2017-04-01 (4)

And they would merge into one column on a temporary table.

   Table: Temp Table
         ------------
 Column: MergedDates
         2017-01-01 (1)
         2017-03-01 (3)
         2017-04-01 (4)
         2017-05-01 (2)

NOTE I cannot alter the original tables, and it is fine if there are duplicate dates. The order does matter but whether it's newest or oldest first does not matter.

and any reason, you cannot use UNION ?

Sudipta Mondal
– Sudipta Mondal

2017-06-28 14:23:44 +00:00
Commented Jun 28, 2017 at 14:23 — Sudipta Mondal
– Sudipta Mondal, Commented Jun 28, 2017 at 14:23

Sudipta Mondal · Accepted Answer · 2017-06-28 14:25:12Z

2

UNION should help you

SELECT DateServiced
  FROM TABLE A
 UNION 
SELECT DateShipped
  FROM TABLE B;

answered Jun 28, 2017 at 14:25

Sudipta Mondal

2,5721 gold badge20 silver badges21 bronze badges

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

1 Comment

Sudipta Mondal Over a year ago

@MatthewBarbara - If the above helped, an accept would be good for others :)

Collectives™ on Stack Overflow

MySQL Merging two columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related