Even though you intend to count the same data, your SQL returns 100 records, while the person you are verifying with gets 98.In such cases, if you immediately add conditions just to make the numbers ...
In this excerpt from SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, John L. Viescas and Michael J. Hernandez discuss the LEFT OUTER JOIN vs. the RIGHT OUTER JOIN and offer ...