title: query sql between two tables
body: <p>i tried query but no have search answer, i have two tables </p>
  
  <p><a href="https://i.stack.imgur.com/iRlrd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iRlrd.png" alt="table 1"></a>  </p>
  
  <p><a href="https://i.stack.imgur.com/Qe3XH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Qe3XH.png" alt="enter image description here"></a></p>
  
  <p>i want design a query in Linq  that get all data that have register in table 2 with value in number field 1 AND value 3 AND value 4 , in this example i get data of the table 1 </p>
  
  <p><a href="https://i.stack.imgur.com/SpRqp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SpRqp.png" alt="enter image description here"></a></p>
  
  <p>thanks for you collaboration</p>