How to write this query..

[masfenix]

Okay, I need to update my users db in an asp.net site I made. Basically I am using a "little" modified version of the default SQLMembershipprovider.

The tables(relative to this question) look as follows:

aspnet_users
userid,
username,
lowered_username


aspnet_membership
userid,
password,
email

What I want to do
For each userid, I need their default username (and lowered_username) in aspnet_users with the email from aspnet_membership.

I want the user to be logging in with their email instead of username.
I don't really have the option to make a custom membership provider.

Thanks!