Unire 3 tabelle con JOIN?

[Teuzzo]

SELECT *
FROM foto
LEFT JOIN model ON foto_modelusername = model_username
LEFT JOIN altratabella ON ...=...
WHERE ...