>>>So, what should I look for? First time I've run across this error!!!!
>>>
>>>Thanks!
>>
>>It wants to know which plan_id to use in the select (even though YOU know it is the same value).
>
>I must have lost my eyesight!
>
>Egads!!! I have looked at this SELECT for about 4 HOURS and did not see the PLAN_ID in the first line!!!!

So now you're sending that plan_id to school?