ALTER PROCEDURE stp_get_Users
	
AS

	Select 
	    U.UserId                 
		,U.UserName               
		,U.IsAnonymous            
		,U.LastActivityDate       
		
		,M.Password               
		,M.Email                  
		,M.PasswordQuestion       
		,M.PasswordAnswer         
		,M.IsApproved             
		,M.IsLockedOut            
		,M.CreateDate             
		,M.LastLoginDate          
		,M.LastPasswordChangedDate
		,M.LastLockoutDate        
		,M.Comment                

	From 
		Users U
	Inner Join 	
		Memberships M
		On U.UserId = M.UserId
	order by 
		UserId

RETURN 0


