List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:November 23 2009 2:29am
Subject:RE: Creating Table Through Union
View as plain text  
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.
Thread
Creating Table Through UnionVictor Subervi22 Nov
  • RE: Creating Table Through UnionGavin Towey23 Nov
    • Re: Creating Table Through UnionVictor Subervi23 Nov