send mail forget password in .net

Question

hi frnds i want to send mail forget password:

 

like username:xyz;

and pass: abc;

i have two different table one client_details

and second wholesale_clientdetails

i wants check if enter email exists any table then send user name password

i use this sp:

 

if(@Operation='Select_forgotpassword')

begin

select Client_Name, Password From Tbl_ClientDetails where Email=@Email

end

but this check only one table

 

how to check both table