passing one query result set in to other query
Hi,
I have two select statements,i want to pass first select statement result set into second select statement in selection clause.
Please help how to make this two select statements as single object.
suppose :- My first select statement is giving the below result set
, DECODE(AVT.TAX_CODE,'COF-C0',DIST.AMOUNT,0 )COF_C0
, DECODE(AVT.TAX_CODE,'COF-D0',DIST.AMOUNT,0 )COF_D0
, DECODE(AVT.TAX_CODE,'COF-OR-C',DIST.AMOUNT,0 )COF_OR_C
, DECODE(AVT.TAX_CODE,'COF-OR-D',DIST.AMOUNT,0 )COF_OR_D
Now i want pass this decode functions in second selection cluase.
Thanks