Join inside a join

Databases
1

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)
2

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

:cool: