Another example

FROM       posts
INNER JOIN like    ON posts.id = likes.postId
LEFT  JOIN votes   ON posts.id = votes.id     AND posts.type = 'poll'
LEFT  JOIN answers ON posts.id = answers.id   AND posts.type = 'questions'

@Ian 👋 You can use

some

with an

AND

condition to achieve the same as shown here.