Subselect questions

From: MD <md_at_md.com>
Date: Tue, 18 Apr 2006 16:40:57 -0500
Message-ID: <H1d1g.16527$IZ2.13038@dukeread07>

Hi,
I'm using 9i and I have this join in a procedure:

INNER JOIN
    (
    Select EscPer.escalationpercent, EscPer.headerid     From delta.tblriversegescalation EscPer

        INNER JOIN 
        (
            Select MAX(EffectiveDate) as EffectiveDate, HeaderID
            From delta.tblriversegescalation seg
            Where trunc(seg.effectivedate) <= trunc(vTripStartDate)
            Group By HeaderID
        ) MaxEsc
        ON MaxEsc.EffectiveDate = EscPer.EffectiveDate
                and MaxEsc.headerid = EscPer.headerid

    ) SegEsc
ON SegEsc.headerid = SegHead.recordid

My question is,
Is there any way to have a local variable declared in a subselect?

Thanks,
MD Received on Tue Apr 18 2006 - 16:40:57 CDT