Need Help for select
От | Andre Schubert |
---|---|
Тема | Need Help for select |
Дата | |
Msg-id | 20020812150640.4acd538b.andre@km3.de обсуждение исходный текст |
Ответы |
Re: Need Help for select
|
Список | pgsql-sql |
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_Name12 | A_Name2 1 | 2 2 | 1 2 | D_Name23 | A_Name3 2 | 1 3 | 2 3 | D_Name34 | 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
В списке pgsql-sql по дате отправления: