Stacking Different Data With The Same Field Names in MySQL
I am working with three tables in MySQL, one from Company A (18,000 records), one from Company B (145,000 records) and one from Company C (8,000 records). Each table has unique data, but has the same exact field names. I need to join all three tables together to stack the data on top of each other, so the data is combined, so there would be 8+18+145= 171,000 records in total in one table. Can anyone help me out with the SQL Query?
Subject
Views
Written By
Posted
Stacking Different Data With The Same Field Names in MySQL
1714
July 01, 2013 08:44AM
667
July 05, 2013 05:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.