Is It Possible to create a Join with Multiple Tables

[[e-mail]]

:Newbie:
Short Question: Is it possible to create an inner join (or another  
join) with multiple tables?

something like

$query_list1 = "SELECT table1.id,table1.status, table2.id, table3.id  
(more here - etc.) FROM table1
INNER JOIN table2 ON table1.id = table2.id
INNER JOIN table3 ON table2.id = table3.id
WHERE table1.status = 'open'";


Q: Is something like this possible?



Thanks,
cool@stripped