|
Posted by Stefan Rybacki on 10/04/67 11:31
iMi wrote:
> Hello to all of you! I would appreciate if someone could help me out. There
> are three tables in my database:
>
> --------------------------------
> | table: sections |
> --------------------------------
> | section_id | parent_id |
> --------------------------------
> 1 0
> 2 1
>
> -----------------------------------------------------
> | table: section_descriptions |
> -----------------------------------------------------
> | section_id | language_id | section_name |
> -----------------------------------------------------
> 1 1 Home
> 1 2 Caza
> 2 1 News
> 2 2 Notizie
>
> ------------------------------------------------------------
> | table: languages
> |
> ------------------------------------------------------------
> | language_id | language_name | language_code |
> ------------------------------------------------------------
> 1 English en
> 2 Italino it
>
> and I need a valid MySQL qury for output as shown below:
>
> --------------------------------------------------------
> | section_id | section_name | section_parent |
> --------------------------------------------------------
> 2 News Home
>
> or
>
> --------------------------------------------------------
> | section_id | section_name | section_parent |
> --------------------------------------------------------
> 2 Notizie Caza
>
>
What did you try so far?
Would this work for you, just a simple join of all the tables?
SELECT a.section_id, b.section_name, d.section_name as section_parent FROM
sections a JOIN
sections c ON (a.parent_id=c.section_id) JOIN
section_descriptions b ON (b.section_id=a.section_id) JOIN
section_descriptions d ON (d.section_id=c.section_id) JOIN
languages l ON (l.language_id=d.language_id AND b.language_id=l.language_id)
WHERE l.language_code='en'
Regards
Stefan
> Thanks in advance!
> ---
> iMi
>
>
Navigation:
[Reply to this message]
|