select * from (countFloorCaps 'BREESE', 4) f inner join (rateCapacity 'BREESE', 4) r on f.floornum = r.floornumAny 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.