On Sun, Nov 22, 2009 at 9:29 PM, Gavin Towey <gto...@ffn.com> wrote: > 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 >
Thank you. V