Every so often I talk myself out of believing I know which JOIN I want to use in SQL-land. "LEFT OUTER doesn't mean "OUTER" from the point of view of the LEFT table does it? There's no way. It's the entire LEFT table's OUTERness. Right? Yes. Right? Well, try it. But it's a compound statement. I don't really want to write a stupid trial statement, do I? I know this. It's all of the LEFT."

"Right?"

This visual review is great. LEFT OUTER JOIN is exactly what I thought it was. (Thanks Denny Green):

Left outer join produces a complete set of records from Table A, with the matching records (where available) in Table B. If there is no match, the right side will contain null.



And continue... That'll last me another year or so.

Labels: