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!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
