Topic: INNER JOIN and LEFT JOIN
Just trying to get a clearer idea of how these two actually differ. Been having a read of the pgsql docs, but I'm still very little the wiser. What exactly are the real world differences? Are there certain scenarios where one or the other should not be used? Any testing I've done always seems to work just as happily with a left join as an inner, so is there a real need to use inner, (as from what I could understand of the docs, an inner join is initially made on a left join anyhow)?
Cheers in advance for any 'drum it into the muppet explanations'.
p.s: Btw, is it just me, or do some queries really need a twisted logic to get correct?