From: Andre Schubert <andre@km3.de>
To: pgsql-sql@postgresql.org
Subject: Need Help for select
Date: Mon, 12 Aug 2002 15:06:40 +0200
Message-ID: <20020812150640.4acd538b.andre@km3.de> (raw)
Hi all,
i need help to build a select query or plpgsql-fucntion
for the following tables.
create table a (
id int,
name varchar(20)
)
create table b (
a_id int,
c_id int
)
create table c (
b_id int,
d_id int
)
create table d (
id int,
name varchar(20)
)
Is it possible to build a select query that selects d.name for each a.name where
a.id = b.a_id and d.id = c.d_id and each b.c_id must exist in c.b_id.
Example:
a: b: c : d:
id | name a_id | c_id b_id | d_id id | name
----|------- -------|----- -------|----- -----|--------
1 | A_Name1 1 | 1 1 | 1 1 | D_Name1
2 | A_Name2 1 | 2 2 | 1 2 | D_Name2
3 | A_Name3 2 | 1 3 | 2 3 | D_Name3
4 | A_Name4 3 | 3 4 | 2
3 | 4 5 | 3
4 | 5
i wish to have to following result:
--------|--------
A_Name1 | D_Name1
A_Name3 | D_Name2
A_Name4 | D_Name3
I hope someone could understand the problem
Thanks in advance and sorry for my bad english
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andre@km3.de
Subject: Re: Need Help for select
In-Reply-To: <20020812150640.4acd538b.andre@km3.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox