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@xxxxxx
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
