What's wrong with this query:

select Table1.*, (select first 1 Table2.A from Table2 where <some_criteria>)
as NAME, Table3.Field1
from Table1
inner join Table3
on NAME = Table3.Field1
where <some_criteria>
order by <some_criteria>

I get an error, that NAME is unknown field.
Is it not permited to use an alias in the join ?

Regards,
Primoz