Ars Technica

"Old Style" SQL Joins using the WHERE clause

SELECT a.au_id, t.title FROM titles t, authors a, titleauthor ta WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND t.title LIKE '%Computer%' SELECT a.au_id, t ...
Visual Studio Magazine

Getting All the Results When Joining with LINQ

Here's a common problem: finding or presenting two collections of related objects where one collection is missing some items. Examples include listing all Customers with their SalesOrders, including ...