Simple Select Problem

[rahaiffi]

i have a simple select problem..

have a 2 table..

table1

NAME
USERNAME

table2
CLASS
NAME

i want to select CLASS FROM table2 WHERE CLASS = $GET['kelas']
AND NAME FROM table1 WHERE USERNAME = $SESSION['MM_Username']

It means select name from table2 = name from table1

how to join this query?
help me..

[NogDog]

$query = "SELECT table2.CLASS, table1.NAME FROM table1, table2 WHERE table1.NAME = table2.NAME AND table1.USERNAME = '{$_SESSION['MM_Username']}'";