First you should mention what language you're writing this stored procedure in. (It probably isn't Java.) And second you should explain how you expect to figure out which of the three e-mail addresses you get in that result set belongs to which ID, given that you don't have the ID in the result set.
Joined: Aug 11, 2010
Hi Im using Java.
And my result set contains all the 3 email id's.
whatever i give in the 'IN' clause, i want to name it acc as email1, email2, email3.