OraFAQ Forum: Reports & Discoverer » How can used UNION STATMENT ACCORDING CONDITION in REPORT?

Home » Developer & Programmer » Reports & Discoverer » How can used UNION STATMENT ACCORDING CONDITION in REPORT?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can used UNION STATMENT ACCORDING CONDITION in REPORT? [message #304414]

Wed, 05 March 2008 01:48

j1968s
Messages: 7
Registered: January 2008

Junior Member

HI ALL

How can used UNION STATMENT ACCORDING CONDITION in REPORT?

I mean that I have two Table , If the date > year(2000) will use one table but if the date < year (2000) will use tow table
IN FORM THAT's NOT problme BUT in report how it's will do it ?

 CASE WHEN DATE  > '01-JAN-2000' then
	SELECT ALL FROM INVOICE WHERE INVOICE_DATE >= DATE
ELSE
	SELECT ALL FROM INVOICE WHERE INVOICE_DATE >= DATE
        UNION ALL
	SELECT ALL FROM ARCHIVE_INVOICE WHERE INVOICE_DATE >= DATE
END

ARE IT'S AVAILABLE ??
THANKS FOR ALL

Report message to a moderator