Can anyone tell me how this LEFT JOIN condition works?

[slate garden]

<@&987246584574140416> please have a look, thanks.

[woeful bronze]

So a LEFT JOIN (short for LEFT OUTER JOIN) will take all the results from the left side (your source) and the ones matching the condition in the join itself

I rarely use outer joins, inner joins is usually what you need, but there's always exceptions ofc

[scarlet lion]

That’s not what I asked 😅 But my question is how can you put something like Author = ‘Tolkien’ in a join clause

[scarlet lion]

In the original post I mean

[solid juniper]

why did you delete it though lol

[scarlet lion]

No one was answering 🥲