On Wed, Apr 13, 2011 at 20:42, Ann Harrison <aharrison@...> wrote:

> The statement SELECT *, (1+1) FROM CITIES runs into the standard SQL
> syntax for a select list...
>
> <select list> ::=
>        <asterisk>
>      | <select sublist> [ { <comma> <select sublist> }... ]
>
> You can either have an unqualified asterisk, or a comma separated
> list.

Or you can use an alias for your table name, like:
SELECT C.*, (1+1) FROM CITIES C

But it's better practice to explicitly specify a list of columns instead of "*".

HTH,
Markus