title: query doesn't return proper value
body: <p>I have a query as given below:</p>
  
  <pre><code>SELECT DISTINCT(FldStrategyID), FldTradeServerName,FldBaseDir,FldBinaryStartTime
  FROM TblOrders Ord,
    (SELECT CONCAT(FldStrategyID,'.',FldTradeServerName,'.',FldBaseDir,'.',FldBinaryStartTime) strid
     FROM TblOrders
     GROUP BY FldStrategyID) as OrderView
  WHERE Ord.FldStrategyID !=''
    AND OrderView.strid NOT IN (SELECT FldStrategyID FROM TblStrategyMasters WHERE 1)
  </code></pre>
  
  <p>The problem is that this part is not working:</p>
  
  <pre><code>OrderView.strid NOT IN (SELECT FldStrategyID FROM TblStrategyMasters WHERE 1)
  </code></pre>