Oracle report union operator
How can I get the result of only First Query when the开发者_开发知识库 condition in the First Query satisfies in a query like Q1 Union Q2.
If I understand your question correctly, then:
Q1
UNION
Q2 WHERE NOT EXISTS(Q1)
That is, you write Q2 so that it never returns anything if Q1 returns any rows.
精彩评论