Analytics Software

Hi
I am new working with brio.

I need to do this in Interactive reporting.

SELECT DISTINCT al1.pdship, al1.pdsddt, al2.pmppds, al1.pditcd, al3.ititds,
al1.pdlimt, al1.pdbkct, al1.pdofct, al1.pdopcl, al1.pdppid,
al2.pmpkid, al2.pmefdt, al2.pmefbt, al2.pmaprv

FROM dpc_resmmx.icppdd@colonial al1, dpc_pssmmx.icppmd@colonial al2, dpc_pssmmx.icitnd@colonial al3


WHERE al2.pmpkid = al1.pdpkid
AND al2.pmppid = al1.pdppid
AND al2.pmcurc = al1.pdcurc
AND al2.pmmkyr = al1.pdmkyr
AND al2.pmsncd = al1.pdsncd


AND al3.ititcd = al1.pditcd


and al1.pdppid='BINGOPAD'
and al1.pdsddt=1110327
AND al1.pdship = 'HR'
AND al1.pdsddt BETWEEN 1110327 AND 1110612
AND (NOT al1.pdppid = 'FIT')
AND al2.pmmkyr = 2011
AND (PMEFDT - DECODE (NVL (PMEFBT, 0), 0, 0, 1, 0.1, 1 / PMEFBT)) =
*(SELECT MAX(PMEFDT*
- DECODE (NVL (PMEFBT, 0),
*0, 0,*
*1, 0.1,*
*1 / PMEFBT))*
FROM dpc_pssmmx.icppmd@colonial AlF
WHERE AlF.PMPKID = al2.PMPKID
AND AlF.PMPPID = al2.PMPPID
AND AlF.PMCURC = al2.PMCURC
AND AlF.PMMKYR = al2.PMMKYR
AND AlF.PMSNCD = al2.PMSNCD)

The text in Blod is my problem the select into the other.

Thanks.