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
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 |