This content has been marked as final. Show 4 replies
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
Then read FAQ
select org.org_cd, vw.subscriber_cd, vw.bac_cd, sub.effective_end_dt
from gmex_cm_org org, gmex_cm_org_subs sub, gmex_cmna_subscriber_vw_new vw
where org.org_id = sub.org_id and
sub.subscriber_cd = vw.dealer_code
and org.org_id = 789
and sub.effective_end_dt < any( sysdate)
Oracle Discussion Forums » Oracle Database » SQL and PL/SQL