SQL - Where Help

I have a tblUsers table. This table is used for username, password and also has their e-mail in it.

The table is accessed in order for them to login. I set a session variable at that point. Session("USERNAME") = rs("Username")

I'm trying to write a SQL statement to get their email address based on the username used in the login.

SELECT email FROM tblUsers where ????

Once I get the e-mail I want to add into CDONTS for an e-mail. The e-mail works fine but I want to add this into the FROM Section.

I hope this clear. Any help would be greatly appreciayted.

Something like that.

Cheers,

Dean