Try doing it in two steps: Create table clients ( table def ); Insert into clients Select * from clients1 UNION Select * from clients 2; ***************************** Jonathan R. Karlen President/Senior Developer Infoniq E-Business Solutions, Inc. http://www.infoniq.com/ (914)-630-4509 -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Sarah Sweeney Sent: Friday, August 20, 2004 10:18 AM To: thelist Subject: [thelist] merging tables in mysql I'm working on a project building a Contact Management System which will, in effect, merge two existing systems. I've done a bunch of work with the databases (SQL Server and Access) to merge them into one (MySQL). Basically, what I've got now are two copies of each table, now sharing the exact same structure. I just need to be able to merge the copies into one single table. I tried this: CREATE TABLE Clients AS (SELECT * FROM Clients1 UNION SELECT * FROM Clients2) but I got a syntax error: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION SELECT * FROM Clients2)' at line 3 However, if I run the SELECT statement all by itself, it works fine. I assume this means that my UNION is not allowed in this instance. Any ideas on how I can merge my tables? BTW, I am using MySQL version 4.0.16-standard. TIA -- Sarah Sweeney :: Web Developer & Programmer Portfolio :: http://sarah.designshift.com Blog :: http://hardedge.ca Family :: http://geekjock.ca -- News! - Evolt.org conference for web professionals. 17-19 September 2004 in Toronto, Canada. Details at http://TOevolt.org * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !