Subject Re: [firebird-support] select statments with both "*" and specific rows
Author Woody
From: "yoav112003" <yoav112003@...>
> Hello
> I am trying to run the following query:
> SELECT rowid, * FROM Events;

Select Events.rowid, Events.* from Events

You must qualify the field names when you use the * and other field names.
At least, that's what I've found needs to be done. This syntax should also
work for the other databases as well.

However, why do you need the redundancy of the rowid field name?


Woody (TMW)