Two SQL NULL Traps: Missing JOIN Rows and UNIQUE Constraints That Do Nothing

NULL behavior varies across databases and causes two common problems: JOIN on NULL columns returns no rows, and UNIQUE constraints allow multiple NULLs. Covers MySQL, PostgreSQL, SQLite, SQL Server with solutions for each.