A upit
Code:
SELECT m.email
FROM aspnet_users u
INNER JOIN aspnet_usersInRoles uir ON u.userId = uir.userID
RIGHT OUTER JOIN aspnet_membership m ON u.userID = m.userID
INNER JOIN aspnet_custom_registrants cr ON m.userID = cr.userID
LEFT OUTER JOIN aspnet_roles r ON r.roleID = uir.roleID
WHERE cr.receiveNewsletter = 1
/* ako dodam ovo, ne vraca nikakve rezultate
AND r.roleName = 'user' */
SELECT m.email
FROM aspnet_users u
INNER JOIN aspnet_usersInRoles uir ON u.userId = uir.userID
RIGHT OUTER JOIN aspnet_membership m ON u.userID = m.userID
INNER JOIN aspnet_custom_registrants cr ON m.userID = cr.userID
LEFT OUTER JOIN aspnet_roles r ON r.roleID = uir.roleID
WHERE cr.receiveNewsletter = 1
/* ako dodam ovo, ne vraca nikakve rezultate
AND r.roleName = 'user' */
Mislim da ste već skapirali šta mi je potrebno. Treba mi upit kojim ću da izvučem email adrese iz tabele aspnet_Membership ali samo za određenu rolu, a da je pritom receiveNewsletter = 1 u tabeli aspnet_custom_registrants.
Da li neko ima rešenje, ubih se sa ovim upitom.
Winners never quit, quitters never win.