Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-09 : 08:41:19
|
| James writes "Hi,I'm using the aspnet membership tables in my website. I have a table, ug_RSVP, which shows me who has RSVP'd for a meeting. I want to also join the aspnet Membership tables so I can tell who is a "full-paid" member (RoleName = member) or "email only" (RoleName = email). The problem is that a member can be either email or email and member. Or the user who RSVP'd isn't in the aspnet_Membership table.SQL*********************************SELECT ug_RSVP.rsvpID, ug_RSVP.meetingID, ug_RSVP.rsvpFirst, ug_RSVP.rsvpLast, ug_RSVP.rsvpAttend, ug_RSVP.rsvpDate, dbo.aspnet_Roles.RoleNameFROM dbo.aspnet_UsersInRoles INNER JOIN dbo.aspnet_Roles ON dbo.aspnet_UsersInRoles.RoleId = dbo.aspnet_Roles.RoleId INNER JOIN dbo.aspnet_Membership ON dbo.aspnet_UsersInRoles.UserId = dbo.aspnet_Membership.UserId INNER JOIN ug_RSVP ON dbo.aspnet_Membership.Email = ug_RSVP.rsvpEmailWHERE (ug_RSVP.meetingID = @eventID) AND (dbo.aspnet_Roles.RoleName = 'email' OR dbo.aspnet_Roles.RoleName = 'Member')************************************Thanks,James" |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-05-09 : 11:33:02
|
| James,If I understand your problem, you also want to see members that are neither email or member, correct?If so, you can just remove the last two parts of your where clause (the two pertaining to RoleName), can't you?Ken |
 |
|
|
|
|
|
|
|
Eliminating duplicate records with aspnet_Roles