Subject sql expression for inline selected fields
Author Andreas Pohl
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