Re: missing FROM-clause entry for table

Raymond O'Donnell schreef:
> On 12/11/2008 18:08, Erwin Moller wrote:
>
>> LEFT OUTER JOIN tblcategorypropertylang AS CPL ON
>> ((CLP.languageid=DRV1.languageid) AND
>> (CPL.categorypropertyid=DRV1.categorypropertyid));
>>
>> ERROR: missing FROM-clause entry for table "clp"
>>
>
> You've a typo in the query - the table alias is CPL, not CLP.
>
Oh my....
/me slaps head against the wall.
And I checked that query 2 times before posting here....

Maybe it is time to call it a day. ;-)

Thanks Ray! (And Adrian)

Regards,
Erwin Moller
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
>
>