Rows disappearing despite LEFT JOIN? Verifying the difference between WHERE and ON with 3 data records

"I thought LEFT JOIN would keep the data on the left, but the number of records decreased when I added WHERE."When creating ...
techtarget

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

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 ...
Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...
InfoWorld

SQL tutorial: Learn SQL on PostgreSQL

Follow this step-by-step guide to install PostgreSQL, load data, connect to a database, and execute SQL queries including table joins PostgreSQL is an open-source, object-relational (also called ...
Visual Studio Magazine

Leverage Joins in Entity Framework To Get Just the Data You Want

Let's say, for example, that you want to retrieve all of the SalesOrderDetails for SalesOrders that have a delivery date in the future. You could write this query to follow the SalesOrderDetail ...