This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
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.