Why not replace this statement by

select t1.f1 as Field1, t2.*
from table2 t2
left join table1 t1 on t1.no=t2.no

I'm used to inline selects myself and never used left (or right) joins, but
I would expect this to be a situation where they would be useful.

Set

At 22:50 16.01.2001 +0100, you wrote:

>Is there a quick'n'easy way to acces to the sql expression of an inline
>selected field?
>
>Example:
>
>select
> (select f1 from table1 t1 where t1.no=t2.no) as Field1,
> t2.*
> from table2 t2
>
>I need "(select f1 from table1 t1 where t1.no=t2.no)" to add my own sql
>where clause. "Field1" will not help at all.
>
>BTW, in real program there are user defined parameters within select clause.
>So it is much more difficult :(
>
>Mit freundlichem Gruss & Best Regards
>
>Andreas Pohl
>apohl@...
>http://www.ibp-consult.com
>
>
>
>
>
>