Dear my friends... I am using postgres and SuSE 9.1 . 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 Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail