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

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/