911564 wrote:what can we do for you when we don't know table_names or columns_names?
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