158
I would like a quick breakdown of the types of MySQL joins. I know of these, the rest I am not sure what they mean.
- comma separated (what exactly is this short for?):
SELECT * FROM a, b WHERE b.id = a.beeId AND ... - show information from a, even if there are no matches in b:
SELECT * FROM a LEFT OUTER JOIN b ON b.id = a.beeId WHERE ...
I have seen other joins, but want to know what makes them different, what is INNER/OUTER, does adding LEFT change things.
I already know how joins work, I just want to know if there are other types of joins, or if they are just different ways to get the same result.