Hello mysql, This is my query:
SELECT countries.*, lnk0.Value AS fraudIndex, lnk1.Value AS enabled FROM o as countries LEFT JOIN l_TINYINT AS lnk0 ON lnk0.FID=countries.ID AND lnk0.TID=55 LEFT JOIN l_TINYINT AS lnk1 ON lnk1.FID=countries.ID AND lnk1.TID=57 WHERE ((enabled=1) AND countries.ParentID=46) ORDER BY Name And this is result: Unknown column 'enabled' in 'where clause' Why? :( 'enabled' is not keyword. Columns aliases seems to be ignored here. MySQL .49max for Windows, table type InnoDB. RS. Query so strange because generated. Really it's SELECT countries.*, countries->\shop\parms\countries\fraudIndex as fraudIndex, countries->\shop\parms\countries\enabled as enabled FROM \shop\parts\countries\% WHERE enabled=1 ORDER BY Name -- Best regards, akul mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php