Finding Missing IDs in a Listing using MySQL's NOT EXISTS Condition

Optimizing Nested Queries with Redundant Union Code in Microsoft SQL Server 2008 R2

Joining Tables Based on Shared Numerical Portion Without Joins or Unions

Setting Columns to Read-Only in a Union Query: A Guide for .NET Developers