Re: Creating Table Through Union

2009-11-22 Thread Victor Subervi
On Sun, Nov 22, 2009 at 9:29 PM, Gavin Towey wrote: > The form would be like: > > CREATE TABLE products > SELECT b0basics, b0fieldValues, s0prescriptions, > s0prescriptions0doctors, s0prescriptions0patient, pics FROM table1 > UNION > SELECT b0basics, b0fieldValues, s0prescriptions, > s0prescripti

RE: Creating Table Through Union

2009-11-22 Thread Gavin Towey
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, Gavi