What are some good examples where SQL's OUTER JOIN is used?
- by Jian Lin
I often get asked the questions in an interview that "what is an outer join in SQL"?
While it can be answered, I wonder what might be some classic and good real life examples where a (LEFT) OUTER JOIN is used?