4 Replies Latest reply: Oct 11, 2012 10:25 AM by Osama_Mustafa RSS

    how to write condition which satisfies all list of values

      I have two tables
      i fired a query on those two tables based on join conditions.
      my requirement is i want to display all the records for a particular code which are already expired(<sysdate). If any of the record is not yet expired then i dont want to display the code record until all the expiry date satisfies