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