Page 1 of 1

Create table w/ sub query

Posted: Fri Mar 16, 2007 12:54 pm
by GeXus
I want to use a sub query to basically duplicate an existing table, but only load in distinct. How would I do this? I can't seem to get the syntax right

Posted: Fri Mar 16, 2007 2:52 pm
by feyd
INSERT INTO .. SELECT form?