title: SQL Select rows on different tables that have the same FK values
body: <p>I need to create a query that list every people able to speak in a country with all the required  languages. I have 3 tables ( country / Language / People) The problem is that I don't have a link between the table Country and People but each table have a foreign key &quot;Language_Id&quot;. My goal is to list every people that have as much language as the Country .
  Here is an example :</p>
  <p>Table People :</p>
  <pre><code>     ID   Name    Language_ID  
  1.   1    Paul    1
  2.   2    Paul    2
  3.   3    Max     1
  4.   4    Ben     2
  5.   5    Paul    3
  6.   6    Ben     3
  </code></pre>
  <p>Table Language :</p>
  <pre><code>     ID   Name
  1.   1    English
  2.   2    Dutch
  3.   3    French
  </code></pre>
  <p>Table Country :</p>
  <pre><code>     ID   Name         Language_ID
  1.   1    France       3
  2.   2    Netherlands  1
  3.   3    Netherlands  2
  4.   4    Belgium      2
  5.   5    Belgium      3
  </code></pre>
  <p>Result table :</p>
  <pre><code>       Name    Country_Name
  1.     Paul    France
  2.     Paul    Netherlands
  3.     Paul    Belgium
  4.     Ben     Belgium
  5.     Ben     France
  </code></pre>
  <p>So , Max is excluded from the results because he doesn't have all the required languages.</p>
  <p>I am running SQL Server 2016 Std edition.</p>
  <p>Could you help me to find a solution ?</p>
  <p>Thank you !</p>