Posted by iMi on 10/12/58 11:31

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


Thanks in advance!
---
iMi

• Next in forum: Re: sql query
• Prev in forum: Re: build WHERE clause on demand
• Thread view: sql query

[Reply to this message]