Frens, i'm in a dilemma ....
i need to join 5 tables using Inner join....
Is this a good practice or it makes any inconsistency in later years..
reply me its very urgent...
just have a look
SELECT Distinct(email) FROM MAP_GROUPS_INTO_ORGANIZATION M INNER JOIN GROUPSDB G on G.ID = M.GROUPID
INNER JOIN aspnet_Roles r ON R.RoleName = G.GROUPNAME
INNER JOIN aspnet_UsersInRoles U ON U.RoleId = R.RoleId
INNER join aspnet_membership a on a.UserId = U.UserId
where G.GROUPNAME = 'GROUP001'
have fun
Shankar.M
-Code, for the future
...
Go to the complete details ...