Re: polating (insert into...) a table with determined record from another table.

From: Harald Fuchs <hf0722x(at)protecting(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: polating (insert into...) a table with determined record from another table.
Date: 2004-07-22 15:44:33
Message-ID: puiscgvyfy.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <20040722131503(dot)82949(dot)qmail(at)web41803(dot)mail(dot)yahoo(dot)com>,
Prabu Subroto <prabu_subroto(at)yahoo(dot)com> writes:

> Dear my friends...
> I created a table (named : sven1). I want to populate
> this table with the record from another table (named :
> appoinment).
> but I don't know how to formulate the sql query.

> I tried this one:
> insert into sven1 (custid, noapp) values ((select
> custid from appointment where done='N' and
> salesid='6'), (select noapp from appointment where
> done='N' and salesid='6'));

It's far easier:

INSERT INTO sven1 (custid, noapp)
SELECT custid, noapp
FROM appointment
WHERE done = 'N'
AND salesid = '6'

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-07-22 17:59:36 Re: Best way to recover from crash?
Previous Message Steve Wampler 2004-07-22 14:14:59 Best way to recover from crash?