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!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/