| From: | Anton Nikiforov <Anton(dot)Nikiforov(at)loteco(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Select statment question |
| Date: | 2004-02-17 19:59:00 |
| Message-ID: | 40327284.4050108@loteco.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron St-Pierre | 2004-02-17 20:06:38 | Re: String manipulation |
| Previous Message | Pascal Polleunus | 2004-02-17 19:55:54 | Re: String manipulation |