I'm well aware of alias and use aliases all the time in Firebird. I use AS for field aliases but not table aliases.
select id AS id_alias from Table Alias delete from Table alias where alias.field = 1 I did not know you could interpose 'alias' between 'DELETE' and 'FROM' but I was just able to test it with MySQL and it does work -- but maybe MySQL is non-standard. However, why not just use DELETE FROM? The 'alias' in that position doesn't seem to add anything and just stops Firebird working. I will try to post my first ticket! On Jan 24, 4:28 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > 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 theproblemis 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 -~----------~----~----~----~------~----~------~--~---
