title: Which is better Sub-Query or JOIN in SQl query?
body: <p>Can any one suggest which one is better in this case:</p>
  
  <h1>1:</h1>
  
  <pre><code>SELECT
      COLUMN1, 
          (SELECT 
              COLUMN2 
          FROM
              TABLE2
          WHERE 
              &lt;some condition&gt;) AS COLUMN2
  FROM TABLE 1 
  </code></pre>
  
  <h1>2:</h1>
  
  <pre><code>SELECT
      T1.COLUMN1,
      T2.COLUMN2
  FROM
      TABLE1 T1
  INNER JOIN 
      TABLE2 T2 ON &lt;some condition&gt;
  </code></pre>