SQL Joins

ASP & ASP.NET Tutorial Series (185/247). Prefer one article? Read the complete ASP.NET tutorial.

Short description

Know when EXISTS beats JOIN for existence checks.

Join tip

SELECT i.Name, c.Name AS Category
FROM Items i
INNER JOIN Categories c ON c.Id = i.CategoryId;