Re: Merging two Tables

[CMS]

I don't have an old version of MySQL to test this with, but this works on 5.0.2.

CREATE TABLE TableC SELECT DISTINCT * FROM (SELECT * FROM A UNION ALL SELECT * FROM B) sq;