title: SQL Help for combining two queries
body: <p>I want to combine these two SQL queries into one. Any idea on how do I do it?</p>
  
  <pre><code>Select A, B, C 
  from table1 
  where condition1
  
  
  select D 
  from table2 
  where table1.B=table2.E 
  </code></pre>
  
  <p>(table2 has the mapping of column B of table1)</p>
  
  <p>I just want to fetch A,B,C,D in a single select query. Any help would be appreciated.</p>