Thread: 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!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail
Prabu Subroto wrote: > 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? You are running out of your resources I believe. You forgot the join between customer and customerdescription. Regards Gaetano Mendola