Sorry to ask such a (hopefully) stupid question. I have everything working now with the new release and am trying to create a MySql Select statement that just refuses to work. See below -- what happens is that I'm trying to extract from the Roles/Membership provider ONLY THE RECORDS thathave a ROLENAME='sub' .... The SELECT is resulting in EVERY record in the Roles/Membership database. What am I doing wrong? BTW, homephone, cellphone, etc are FIELDS I *added* to the Table.)
Thanks so much ... (PS - I *finally* had an epiphony in seeing how METHODS work !!!!! Yea ..)
SELECT firstName, lastName, Email, homePhone, cellPhone, workPhone, rolename
FROM aspnet_membership
INNER JOIN `aspnet_roles`
ON aspnet_roles.rolename = 'sub'
ORDER BY firstName