Received: from bilbo.websightsolutions.com (dial200-7.mixcom.com [207.250.200.7] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id IAA16123 for ; Fri, 18 Jun 1999 08:39:33 -0400 (EDT) (envelope-from dgreer@websightsolutions.com) Received: from george (root@george.websightsolutions.com [207.250.200.13]) by bilbo.websightsolutions.com (8.9.3/8.9.3/Debian/GNU) with SMTP id HAA07997 for ; Fri, 18 Jun 1999 07:37:42 -0500 From: Darren Greer Reply-To: dgreer@websightsolutions.com Organization: Websight Solutions To: pgsql-sql@postgresql.org Subject: Trouble with insert into. Date: Fri, 18 Jun 1999 06:38:25 -0500 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <9906180648350D.02503@george> Content-Transfer-Encoding: 8bit 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