title: Sql left inner join + where causes (closed)
body: <p>I have two tables and I want to choose the value on the left, but not on the right table. I know that is easy. <strong>"Left Join"</strong> and <strong>"Where is null"</strong> but I need a second where causes. "Column2 = 1" in right table.</p>
  
  <p><a href="https://i.stack.imgur.com/vD2b4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vD2b4.png" alt="enter image description here"></a></p>
  
  <p>Sorry about my English. I hope this image is enough to show my problem. I need to select the <strong>T</strong> and the <strong>K</strong> areas in one statement.</p>