selecting more that 2 tables based on 1 subquery find an error
Dear my friends... I want to "select" query 2 tables. one is "customer" and one is "customer.description" but the customer records that I want to "select" are only what in subquery result. Here what I've done: " postgres@patrix:~> select c.custid, cd.description, c.company, c.title, c.salutation, c.firstname, c.lastname, c.address, c.postcode, c.city, c.areacode, c.phone, c.mobilephone, c.fax, c.email from customer as c, customerdescription as cd where c.custid in (select custid from sven1); bash: syntax error near unexpected token `cd.description,' postgres@patrix:~> " Anybody could give me any solution? Thank you very much in advance. __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo
participants (1)
-
Prabu Subroto