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