Retrieve Name based on user email and password using Join query in SQL Server

JOYSON

SOLVED CLOSED ACTIVE ANSWERED
User: JOYSON
Posted: on Jun 07, 2017 03:41 AM
Forum: SQL Server
Answer: 1
Views: 3059

Hi,

I Have two table namely "Userlogin" and "tblmcustomer"

I taking one values from each table and gernerting corresponding value in to a label

Here is my sql query in SP

SELECT tblmcustomer.name FROM tblmcustomer INNER JOIN userlogin ON tblmcustomer.userid=userlogin.userid

but each time i insert different mail id and password same name is shown in label.

Please correct my sql query

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Jun 07, 2017 04:03 AM
Report

Refer the below sample query and change as per your table structure.

CREATE PROCEDURE GetName
	@Mailid VARCHAR(50)
	@Password VARCHAR(50)
AS
BEGIN
	SELECT tblmcustomer.name FROM tblmcustomer
	INNER JOIN userlogin ON tblmcustomer.userid = userlogin.userid
	WHERE userlogin.mailid = @Mailid AND userlogin.[password] = @Password
END

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Retrieve Name based on user email and password using Join query in SQL Server

Company

Explore

Follow us

Contact Us