Re: [GENERAL] Assistance with SQL

2008-09-01 Thread Aaron Burnett
Thank you. I was making it way too over-complicated. Works perfectly On 9/1/08 3:39 AM, "hubert depesz lubaczewski" <[EMAIL PROTECTED]> wrote: > On Sun, Aug 31, 2008 at 11:31:32PM -0400, Aaron Burnett wrote: >> table1 has 25 columns >> table2 is a subset of table1 (create table2 as select >>

Re: [GENERAL] Assistance with SQL

2008-09-01 Thread hubert depesz lubaczewski
On Sun, Aug 31, 2008 at 11:31:32PM -0400, Aaron Burnett wrote: > table1 has 25 columns > table2 is a subset of table1 (create table2 as select > id,field1,field2,field3,field4,field5,field6 from table1) with just 7 > columns > There is a primary key on ID > table2 was exported to a CSV, truncated,