Time to read: ~1.5 minute
Update: 2018-03-22 – Had the wrong link to Warren’s post on Join-Object; Added more examples on request.
Update: 2018-03-23 – Code and screenshot for LEFT JOIN was actually for FULL OUTER JOIN. Updated
And no I’m not talking about -join