I suggest you post the actual sql statement. The example you cite can
easily be rewritten as

select t1.f1 as Field1, t2.*
from from table1 t1, table2 t2
where t1.no=t2.no

or using a JOIN expression (preferred).

In any case, if we can't express this as a one-liner, we can help write a
stored procedure to do it.

Art Metz
AMetz@...

> -----Original Message-----
> From: Andreas Pohl [mailto:apohl@...]
> Sent: Tuesday, January 16, 2001 1:50 PM
> To: IBObjects@egroups.com
> Subject: [IBO] sql expression for inline selected fields
>
>
> 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
>
>
>
>
>