From: | Darren Greer <dgreer(at)websightsolutions(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Trouble with insert into. |
Date: | 1999-06-18 11:38:25 |
Message-ID: | 9906180648350D.02503@george |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Mathew White | 1999-06-18 14:24:11 | RE: [SQL] Trouble with insert into. |
Previous Message | Hub.Org News Admin | 1999-06-18 01:10:23 |