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,

[GENERAL] Assistance with SQL

2008-08-31 Thread Aaron Burnett
Hi, I¹m hoping someone can help me out on this one. Two tables 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, then th