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?

HTH

Woody (TMW)