title: Write correlated subquery in a WHERE Clause as join
body: <p>I have a query like below:</p>
  
  <pre><code>select 
    a.id, a.title, a.description
  from
    my_table_name as a
  where
    a.id in (select id from another_table b where b.id = 1)
  </code></pre>
  
  <p>My question is, is there any way I can avoid the subquery in where clause and use it in from clause itself without compromising of performance?</p>