you can replace the subquery
with a stored proc.

mariano

> -----Original Message-----
> From: PUB: Michael Vilhelmsen [mailto:Michael.Vilhelmsen@...]
> Sent: Viernes, 20 de Septiembre de 2002 09:01
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Select in select
>
>
> Hi
>
> Can I do something like:
>
> Select Count(*) from (Select * from TABLE1 where FIELD=180);
>
> Michael
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> 4 DVDs Free +s&p Join Now
> http://us.click.yahoo.com/pt6YBB/NXiEAA/MVfIAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>