Select statment question

select dt1.text as name, dt2.text as description
from dictionary_text dt1, dictionary_optiongroup do, dictionary_text dt2
where dt1.label = do.name and do.description = dt2.label;

not tested :)

Anton Nikiforov wrote:

Is this what you need?

Select dt1.text as name, dt2.text as description
From dictionary_optiongroup do, dictionary_text dt1, dictionary_text dt2
Where dt1.label=do.name
And dt2.label=do.description

Cheers.

Oleg

-----Original Message-----
From: Anton Nikiforov [mailto:Anton.Nikiforov@loteco.ru]
Sent: Tuesday, February 17, 2004 12:59 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Select statment question

Dear All,
could you please help me with writing select statment for the following:
I have two tables dictionary_text
label| Text
-----+------------------------
23 | General
24 | Internet
25 | General option group
26 | Internet option group

And
dictionary_optiongroup
id | name | description
----+------+-------------
0 | 23 | 25
1 | 24 | 26

How should i write SELECT statement to get the following:
name | description
---------+----------------------
General | General option group
Internet | Internet option group

I understand that maybe this question is not for this list, but my
brains stuck with this select. Could you please help.

Best regards,
Anton

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

*************************************
This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.
*************************************