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 (revision) |
Date: | 2004-07-26 11:41:02 |
Message-ID: | 20040726114102.34269.qmail@web41803.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear my friends...
I am using SuSE 9.1 and postgres.
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:~> psql kv
Welcome to psql 7.4.2, the PostgreSQL interactive
terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
kv=# 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);
Terminated
postgres(at)patrix:~>
Anybody could give me any solution?
Thank you very much in advance.
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-07-26 12:37:58 | Re: selecting more that 2 tables based on 1 subquery find an error |
Previous Message | Prabu Subroto | 2004-07-26 11:34:07 | selecting more that 2 tables based on 1 subquery find an error |