RE: [suse-programming-e] selecting more that 2 tables based on 1 subquery find an error (revision)

26 Jul 2004


      It's solved.

Thank you very much for your kindness.
--- "Wenzel, Scott"  wrote:
...
You are actually talking about 3 tables.  You must
link the first 2 tables.
I am assuming you have custid as a field on
description table.  If you have
a large number of rows, make sure you properly tune
your database.  I am
assuming this is a small number of rows for
learning.  I am reformatting
your query.
It should go something like 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 c.custid = cd.cust_id
and c.custid in (select custid from sven1);
Hope this helps..
-Scott
-----Original Message-----
From: Prabu Subroto [mailto:prabu_subroto@yahoo.com]
Sent: Monday, July 26, 2004 7:41 AM
To: suse-programming-e@suse.com
Subject: [suse-programming-e] selecting more that 2
tables based on 1
subquery find an error (revision)
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@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@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
-- 
To unsubscribe, email:
suse-programming-e-unsubscribe@suse.com
For additional commands, email:
suse-programming-e-help@suse.com
Archives can be found at:
http://lists.suse.com/archive/suse-programming-e
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail