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 -
- "Erwin Moller" <[EMAIL PROTECTED]> wrote:
> Hi group,
>
> I get a mysterious errormessage while executing the following query:
> (I left the tabledefinitions out, since I think they don't matter. If
> I
> am wrong I'll be happy to post them.)
>
> SELECT DRV1.languageid, DRV1.categorypro
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
