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:
> 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
>
