Hi guys, I need some help here, please...
I dont know why I am getting this error, I think this morning i ran this query without errors and it worked.. or maybe I tweaked it a little and now I can't remember ((((
I am trying to merge two different tables from two different databases under the same user into one table, the tables have the same fields, but different values, and I want a big table with the fields from the 2 merged tables.
Lets call the 2 databases db1 and db1
I am using:
CREATE TABLE jos_camp_merged engine = MERGE UNION = (db1.jos_camp_contacts,db2.jos_camp_contacts);
And i get
"#1113 - A table must have at least 1 column "
Do you know what I am doing wrong please??? Thanks in advance.