i'm creating report ireport on oracle db. have select values depending on condition this:
and exists (select 1 table_1 x = y) or exists (select 1 table_2 z = y) is possible execute second exists if first false?
try use conditions in brackets:
and ( exists (select 1 table_1 x = y) or exists (select 1 table_2 z = y) )
Comments
Post a Comment