I just found this: http://www.1keydata.com/sql/sqlalias.html
That describes using alias without the 'AS' I mentioned above (which is needed in MySQL). In this reference, they use the alias feature as described in villas original post: SELECT "table_alias"."column_name1" "column_alias" FROM "table_name" "table_alias" So it looks like the original query was syntactically correct (at least for some db systems). Maybe the problem is that FirebirdSQL doesn't support aliases at all?? Dave --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
