MySQL Forums
Forum List  »  German

Stacking Different Data With The Same Field Names in MySQL
Posted by: Eric Siegel
Date: July 01, 2013 08:44AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
Stacking Different Data With The Same Field Names in MySQL
1714
July 01, 2013 08:44AM


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.