> I know, I know.
> Just strange for me why can I use an alias which is a table name also.
> I don't have problem with this but I don't know this is a feature or a
> bug or this is an SQL Standard thing.

The SQL standard allows for an Alias to be almost anything.

The fact that someone would use a table name as an alias is not wrong,
but "ill advised" as it makes the SQL more difficult to read.

The same is true for the "as" optional word for the alias, which makes
the SQL easier to read.


Sean