>>could someone please explain what is a left join any why using it exclusively is a problem? reply There is nothing wrong with it per se, it depends on the qu

>>could someone please explain what is a left join any why using it exclusively is a problem? reply There is nothing wrong with it per se, it depends on the question you are trying to answer - gauging someones competence based on the absolute number of times someone uses a left join, vs right join, vs outer join during their career is silly - almost any query can be written multiple ways to get the exact same results. What matters is did the developer get the correct results. It's good to have a sense of what other join types do, but if they don't get you to the answer you want any faster or better, so what?