How to manipulate large data without creating temp table or using array

Hi All,

I have a sql query which fetches large number of records for sybase DB and then i use the one column value and do a select on other table in other DB(SQL). I want to do it on the fly as i dont want to use any temp file or array. Any help will be appreciatable.

Thanks,
Veekoul