StandardFusion interview question

Q: What is left-join in DB?