Received: from fundgroup.com (guru.fundgroup.com [207.135.128.220]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA79810 for ; Fri, 18 Jun 1999 10:20:18 -0400 (EDT) (envelope-from guru@fundgroup.com) Received: from mat.fundgroup.com (mat.fundgroup.com [192.168.1.15]) by fundgroup.com (8.9.3/8.9.3) with SMTP id IAA04399; Fri, 18 Jun 1999 08:23:09 -0600 Received: by localhost with Microsoft MAPI; Fri, 18 Jun 1999 08:24:13 -0600 Message-ID: <01BEB963.F2504400.guru@fundgroup.com> From: Mathew White To: "'dgreer@websightsolutions.com'" , "pgsql-sql@postgreSQL.org" Subject: RE: [SQL] Trouble with insert into. Date: Fri, 18 Jun 1999 08:24:11 -0600 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi. I'm new to mailing lists, so let me know if I don't post properly. Here is an SQL statement that I found that works for what you are doing (your own SQL statement was very close). Note the text conversion for the zip field. insert into tableB select l.username, '4-15-1999', l.zip::text from tableA l where not exists ( select ld.username from tableB ld where ld.username = l.username ) ; On Friday, June 18, 1999 5:38 AM, Darren Greer [SMTP:dgreer@websightsolutions.com] wrote: > Hello all. Lets say I have: > Table A (username text, first_name text, last_name text, zip int4) > Table B (username text, signupdate date, zip text) > > In table A I have > user1 fred jones 53125 > user2 bob smith 52145 > > In table B I have > user2 06/16/1999 52145 > > The way these tables were populated, table A and B were written to > at the same > time. However, table B, did not exist for the first 6 months of > use. So there > are many users who are in table A, that are not in table B. > > Now what I am tryign to do, is insert all users that dont exist in > table B, > that exist in table A, into table B. With o ne twist. Signup date > does not > exist in table A, so I need to insert them all with an arbitrary > date. I plan > on putting them all in as 04/15/1999. > > Here is the select statement I was able to get to work: > select l.username, l.zip > from tableA l > where not exists ( > select ld.username > from tableB ld > where ld.username = l.username > ); > > Now my difficulty comes in inserting the data that is retrieved into > table B. > > If anyone can help me out, I would greatly appreciate it. > > Thanks, > > Darren > >