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