Extract many-to-many to many-to-many in one query

 

How to extract many-to-many to many-to-many in one query

We have three tables: `country`, `news` and `country_news` that is used to support a many-to-many relationship between news and countries. A country has many news and news can be from many countries.

I want to find all new for specified country, and then I want to select the countries associated with the found news.

 

Leave a Reply

Your email address will not be published. Required fields are marked *