Combine tables from multiple indentical table source

[lovedieer]

I have 25 different backend data from different states for a survey data and each state have exactly the same data structure. The only thing is their primary key ( surveycode ) is 11000xxxxx, 12000xxxxx , 13000xxxxx....25000xxxxx for different state.

I want to comebine these 25 backend in one big table and keep the same surveycode for each person). Is there any good way to combine these data into one.

Anyhelp is appreciated.

 

[pbaldy]

Try a UNION query:

SELECT Field1, Field2
FROM Table1
UNION ALL
SELECT Field1, Field2
FROM Table2

 

[lovedieer]

Do you mean I have to upload all the different backend to the same file and then do the union.

 

[gemma-the-husky]

well ideally, you wouldnt have 25 different databases (or tables)

everything would just be in a single table.

 

[pbaldy]

You could link to each.