How to get values using stored procedure

Question

Hi  This is my table structure : i want to get MemberTeams based on memberid please give a stored procedure for that

Azeem Anzari · Answer

select C.TeamNameD.MemberName from TeamMember a join MemberLogin b on a.MemberLoginID=b.MemberLoginID Join Team c on c.TeamID= a.TeamID join Member D on b.MemberID= d.MemberID where d.MemberID=@MemberID you have to pass the memberID to the procedure you can use this query to create store procedure tell me if its working regards Azeem