A left join is when each item in the first collection is returned regardless of whether it has any related items in the second collection. For instance, say you want to find out how many orders were made for each product in your store.  You also want to see the products that did not have any orders […]