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

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'));

But I got this error in my psql console:
kv=# 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'));
ERROR:  more than one row returned by a subquery used
as an expression
kv=#

Anybody would be so nice to help me solving this
problem?

Thank you very much in advance.



__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

In article <20040722131503.82949.qmail@web41803.mail.yahoo.com>,
Prabu Subroto <prabu_subroto@yahoo.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'

It's solved....

Thank you very...very...much my friend Harald.
--- Harald Fuchs <hf0722x@protecting.net> wrote:
> In article
>
<20040722131503.82949.qmail@web41803.mail.yahoo.com>,
> Prabu Subroto <prabu_subroto@yahoo.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'
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
>       joining column's datatypes do not match
>





__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/