Join tables query

[angelo rigo]

Hi
I need to select news from a news table with the same sport code related in a news_sports table:

news table:
id_news
title

news_sports table:
id_news
id_sport

the querys would be:
//Select many sports id in news_sports with id_news being the only researched new
$sql_rel1 = "SELECT id_sport FROM news_sport WHERE id_news = $bd_id_news"

//Select many news ids in news_sport wich id_sport = sports id researched by the last query
$sql_rel2 = "SELECT id_news FROM news_sport WHERE id_sport = $bd_id_sports"

//Select mews id in news table with the resulting ids from the last query
$sql_rel3 = "SELECT id_news, title FROM news WHERE id_news = $bd_id_news"

This can be done with only one query? how can it be done?

Or:

Do i have to use many querys and do a foreach or something like this?

Thank´s in advance