What are common SQL join types and when do you use them?

Inner joins return matches, outer joins preserve unmatched rows from one or both sides depending on the type.