Hi All,

I have a sp which I would like it to search on a certain table and then with it's results do anothr search on another table.

so I have something like this.

select ID from Table1

select fName from Table2 WHERE ID = Table1ID

see what I mean?