Hi,

With Select-SQL can I get data from ASPNet_Users and ASPNet_MemberShip like this example:

Select ASPNet_Users.UserID, ASPNet_Users.UserName, ASPNet_MemberShip.Password, ASPNet_MemberShip.EMail 
from ASPNet_MemberShip inner join ASPNet_Users on ASPNet_Users.UserID = ASPNet_MemberShip.UserID

But, in my case, I need to get data from ASPNet_Roles too like this:

Select ASPNet_Users.UserID, ASPNet_Users.UserName, ASPNet_MemberShip.Password, ASPNet_MemberShip.EMail, ASPNet_Roles.RoleName
from ASPNet_MemberShip inner join ASPNet_Users on ASPNet_Users.UserID = ASPNet_MemberShip.UserID
  inner join ASPNet_UsersInRoles on ASPNet_UsersInRoles.UserID = ASPNet_Users.UserID
  inner join ASPNet_Roles        on ASPNet_Roles.RoleID = ASPNet_UsersInRoles.RoleID

Can you help me ?