Hi,
I'm Getting Duplicate values from stored procedure,
this is my table structure :
and this is my stored procedure :
ALTER PROCEDURE [dbo].[uspGetAllMemberTeam](@MemberID INT)
AS
BEGIN
select t.TeamName,t.TeamID,t.TeamStatus, m.MemberName from TeamMember tm join MemberLogin ml on tm.MemberLoginID=ml.MemberLoginID
Join Team t on t.TeamID= tm.TeamID
join Member m on ml.MemberID= m.MemberID
where m.MemberID=@MemberID and t.TeamStatus='1'
END
but am executing stored procedure getting duplicate values like TeamID, TeamName
in MemberLogin table i enter the MemberID '1' two columns so getting duplicate values
please give a help