Anand,

with a scenario like that - select some value from one table and then select something else from
another table using the results from the first query - I'd go for a selectable stored procedure.


Florian