LEFT JOIN Question?

[Rayn]

Is there a way to have more than one LEFT JOIN? An example would be like:

SELECT user.,user2.,user3.* FROM user LEFT JOIN user2.id=user.id LEFT JOIN user3.id=user2.id WHERE id=1

Thanks for your help
- Dan

[Lars_Berg]

Yes

SELECT user.*,user2.*,user3.* 
FROM user LEFT JOIN user2 
on user2.id=user.id LEFT JOIN user3
on user2.id=user3.id 
WHERE user.id=1