Table Alias

Hi,

I'm trying to perform a self join e.g.:

select a.name, b.age

from users a, users b;

However, I get a

java.sql.SQLException: [SQL0104] Token A was not valid. Valid tokens: , FROM INTO.

What syntax should I use on the from clause to set up the alias?

Thanks.

Paul.

[324 byte] By [paul_uka] at [2007-11-27 2:07:45]