Re: Subselect questions

From: MD <md_at_md.com>
Date: Tue, 18 Apr 2006 16:43:09 -0500
Message-ID: <L3d1g.16537$IZ2.16075@dukeread07>

The error is Invalid Identifier -- which is because I assume its out of scope, but I need it there.

Thanks

  "MD" <md_at_md.com> wrote in message news:H1d1g.16527$IZ2.13038_at_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:43:09 CDT