Posted!
#3984 (Delete {alias} from Table - non-standard SQL which stops
Firebird working)
I'm so happy to finally try and contribute, I just hope I've done the
right thing and don't waste anyone's time :-)
On Jan 25, 12:33 am, villas <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
