Posted by [IP Address: 137.237.29.94] 'Rebecca' on May 18, 2001 at 16:38:34 EST:

In Reply to: SQR Select Statement problem posted by [IP Address: 137.237.29.94] 'Meera' on May 18, 2001 at 15:12:17 EST:

: I wrote a mutliple Report program But I seem to be getting this error, could any one help me out . Thanks

: The code:

: Begin-Select
: C.Emplid
: C.Plan_Type
: C.Effdt
: D.Dependent_Benef

: Move 'Y' To $Term
: Do Print_Terminated_Dependents
: Show 'Dep Term found =' &D.Dependent_Benef
: 'for Employee ' &C.Emplid
:
: From Ps_Health_Benefit C, Ps_Health_Dependnt D
:
: Where C.Emplid = A.Emplid
: And C.Plan_Type = A.Plan_Type
: And C.Emplid = D.Emplid
: And C.Plan_Type = D.Plan_Type
: And C.Effdt = D.Effdt
: And C.Effdt = (Select Max(E.Effdt From Health_Benefit E
: Where C.Emplid = E.Emplid
: And C.Plan_Type = E.Plan_Type
: And C.Effdt < &A.Effdt)
: And D.Dependent_Benef Not In
: (Select F_Dependent_Benef
: From Health_Dependent F
: Where C.Emplid = F.Emplid
: And C.Plan_Type = F.Plan_Type
: And C.Effdt < &A.Effdt
: End-Select !This is line 153

: The Error:
: Error on line 153:
: (SQR 3716) Error in SQL Statement

Where is this Table 'A' coming from that you have referenced in your where criteria?

Follow Ups:

• Re: SQR Select Statement problem Meera 10:05:39 5/22/01 EST (1)
  • Re: SQR Select Statement problem Rebecca 14:47:25 5/23/01 EST (0)

Post a Followup