The form would be like:
CREATE TABLE products
SELECT b0basics, b0fieldValues, s0prescriptions,
s0prescriptions0doctors, s0prescriptions0patient, pics FROM table1
UNION
SELECT b0basics, b0fieldValues, s0prescriptions,
s0prescriptions0doctors, s0prescriptions0patient, pics FROM table2
Regards,
Gavin Towey
-----Original Message-----
From: Victor Subervi [mailto:victorsubervi@stripped]
Sent: Sunday, November 22, 2009 10:56 AM
To: mysql@stripped
Subject: Creating Table Through Union
Hi;
I would like to create a table out of merging the fields in other,
previously created tables. I have the following syntax which doesn't work:
create table products union (b0basics, b0fieldValues, s0prescriptions,
s0prescriptions0doctors, s0prescriptions0patient, pics);
Please advise.
TIA,
Victor
The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies
of the original message.
