MySQl-selecting from mult. tables

[Dexter Coehlo]

Hi fellow Persters,

An easy quest.

How to select a field from multiple tables(the syntax for MySQl)

I tried select from table1,table1, where useremail="$email"

Thanks

Dexter