reflexive joins

the following sql statement will not run under oracle:

select * from foo as a1, foo as a2 where a1.x > a2.x

it appears as though the "as" in the from clause is not valid. can anyone tell me the syntax for performing such a reflexive join?

thanks,

ben Received on Mon Mar 05 2001 - 15:58:26 CST