I'm pretty new to MySQL and am trying to work out a somewhat more advanced query. I have 2 tables:

userdata - username, pass, email etc
userpref - site settings

What I need to do is find all of the users who have the nofity settings set to 1 within userpref. For some reason I haven't been able to wrap my mind around how to query both tables.

Any assistance will be greatly appreciated. Thanks!