join inside a join

[Jaynesh]

Is it possible to add a join inside a join for e.g

LEFT JOIN 

(dbFriends LEFT JOIN dbPosts_share ON dbPosts_share.share_user_id = dbFriends.friend_id)

ON
(dbPosts.username_id = dbFriends.my_id
OR 
dbPosts.username_id = dbFriends.friend_id)

[r937]

no

joins are serial

start with a table, join a second table, then join another table, then join another table, etc.

and you're still messing around with ORs, aren't you