You cannot use stored procedures in queries. In Sql 2000 you can use UDF's that return table data type in queries.

>Im tyring to use 2 stored procedures, both returns rows, as a source in a select statement. I just want to join the results of 2 sp's. Ive been trying for a while now but I keep getting syntax errors. This is what I want to theroetically do.
>
>

>select * from (countFloorCaps 'BREESE', 4) f
>  inner join (rateCapacity 'BREESE', 4) r on f.floornum = r.floornum
>

>
>Any ideas, I dont want to use any temp cursors. If it cant be done, its not that big of deal, This would just save me a extra trip to my db server and a extra query inside FoxPro.
>
>TIA
>
>Eric Stephani