Select items with same catehory as given item

[Jadow]

Hey

I have two tables:

TABLE_ARTICLE
article_id******article_name article_content

TABLE_ARTICLE_SECTION
article_id *section_id
Given an article_id, how do I select all articles from
TABLE_ARTICLE that have the same section_id as that of a given
article_id.

Something like this but for mysql:
SELECT table_article.* FROM table_article,table_section WHERE
table_section.section_id IN (SELECT section_id FROM table_section
WHERE article_id="something")

Thanks
Joshua

[BDR]

select * from TABLE_ARTICLE
LEFT JOIN TABLE_ARTICLE_SECTION ON
(TABLE_ARTICLE.article_id=TABLE_ARTICLE_SECTION.ar ticle_id)
WHERE TABLE_ARTICLE.article_id='something'

Check mysql.com for other variants on this same theme... "table JOIN(s)"
http://www.mysql.com/doc/en/JOIN.html

Jadow wrote:

Hey

I have two tables:

TABLE_ARTICLE
article_id article_name article_content

TABLE_ARTICLE_SECTION
article_id section_id
Given an article_id, how do I select all articles from
TABLE_ARTICLE that have the same section_id as that of a given
article_id.

Something like this but for mysql:
SELECT table_article.* FROM table_article,table_section WHERE
table_section.section_id IN (SELECT section_id FROM table_section
WHERE article_id="something")

Thanks
Joshua

[BDR]

select * from TABLE_ARTICLE
LEFT JOIN TABLE_ARTICLE_SECTION ON
(TABLE_ARTICLE.article_id=TABLE_ARTICLE_SECTION.ar ticle_id)
WHERE TABLE_ARTICLE.article_id='something'

Check mysql.com for other variants on this same theme... "table JOIN(s)"
http://www.mysql.com/doc/en/JOIN.html

Jadow wrote:

Hey

I have two tables:

TABLE_ARTICLE
article_id article_name article_content

TABLE_ARTICLE_SECTION
article_id section_id
Given an article_id, how do I select all articles from
TABLE_ARTICLE that have the same section_id as that of a given
article_id.

Something like this but for mysql:
SELECT table_article.* FROM table_article,table_section WHERE
table_section.section_id IN (SELECT section_id FROM table_section
WHERE article_id="something")

Thanks
Joshua