selecting more that 2 tables based on 1 subquery find an error

From: Prabu Subroto <prabu_subroto(at)yahoo(dot)com>
To: Postgres General Milis <pgsql-general(at)postgresql(dot)org>
Subject: selecting more that 2 tables based on 1 subquery find an error
Date: 2004-07-26 11:34:07
Message-ID: 20040726113407.46577.qmail@web41807.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)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

Browse pgsql-general by date

  From Date Subject
Next Message Prabu Subroto 2004-07-26 11:41:02 selecting more that 2 tables based on 1 subquery find an error (revision)
Previous Message Matthew D. Fuller 2004-07-26 11:22:13 Re: Sql injection attacks