Thread: Re: selecting more that 2 tables based on 1 subquery fi

Try this:

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 exists (
(select '1' from sven1 ss
 where  c.custid = ss.custid);

Duane

-----Original Message-----
From: Prabu Subroto [mailto:prabu_subroto@yahoo.com]
Sent: Monday, July 26, 2004 4:34 AM
To: Postgres General Milis
Subject: [GENERAL] 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!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly