title: Oracle SQL - achieve MAX functionality in where clause?
body: <p>Two tables:</p>
  
  <pre><code>ItemComment(ItemId, ItemComment, DateCommentPosted)
  Item (ItemId, ItemName, ItemPrice) 
  </code></pre>
  
  <p>I need itemname and price of items that have not received any comment since say last 6 months. </p>
  
  <p>I know this won't work: </p>
  
  <pre><code>SELECT i.itemid, i.name, i.price 
    FROM Item i, ItemComment c
   WHERE i.itemid = c.itemid 
     AND Max(c.dateCommentPosted) &lt; (add_months(SYSDATE,-6));
  </code></pre>
  
  <p>There are answers to similar things on StackOverflow, but Oracle is not liking it.  Any Oracle-specific thing?</p>