I have loaded all my Databases into MySQL. I need to query 14 databases simultaneously. I have two two columns that are consistent across all 14, orderID and cartorderID.
The orderID is the Primary and cartorderId is the Foreign key. There are about 30 to 40 columns per database with other data that I need to ignore. The data extracted needs to be joined into a single row. I may remove the duplicates later with another tool so I'm not concerned with duplicates. At this point the final output table can be called anything because I will be renaming it later in the script.
Any help offered is greatly appreciated. Thanks in advance.