title: How to create left join using only an inner join?
body: <p>I recently had an interview and I was asked how to create a left join by only using an inner join. The interviewer said to me some of the software they use in the company doesn't allow the use of left joins so we have to use inner joins to do them. I was stubbed with the question and I was wondering does anyone here know how to do it?</p>