title: SQL query, where = value of another table
body: <p>I want to make a query that simply makes this, this may sound really dumb but i made a lot of research and couldn't understand nothing. </p>
  
  <p>Imagine that i have two tables (table1 and table2) and two columns (table1.column1 and table2.column2).</p>
  
  <p>What i want to make is basically this:</p>
  
  <pre><code>SELECT column1 FROM table1 where table2.column2 = '0'
  </code></pre>
  
  <p>I don't know if this is possible.</p>
  
  <p>Thanks in advance, </p>