title: Select syntax inside WHERE
body: <p>How do I use <code>SELECT</code> syntax inside <code>WHERE</code> for example I have following code:</p>
  
  <pre><code>SELECT 
      blah...blah..
      ...
  WHERE  
  (
    (APM_AlertsAndReportsData.ApplicationName = 'instance: tomcat6_noram (SNMP)') AND 
    (APM_AlertsAndReportsData.ComponentName = 'Memory Heap Used (B)') AND 
    (APM_AlertsAndReportsData.StatisticData &gt;= 1908932600)
  )
  </code></pre>
  
  <p>Here I am comparing values if its greater than or equal to <code>1908932600</code>. I want to use <code>SELECT</code> in place of <code>1908932600</code> so it will automatically compare values rather than statically code in query. </p>