Subject | sql expression for inline selected fields |
---|---|
Author | Andreas Pohl |
Post date | 2001-01-16T21:50:25Z |
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
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