Tag: COALESCE

• MySQL query using COALESCE() with multiple JOINs returns unexpected NULLs
• PostgreSQL query returning NULL values when using COALESCE with subselect for default values
• SQL Server: advanced patterns when using COALESCE with NULL values in joins
• SQLite: Unexpected results in JOIN when using a COALESCE function with NULL values in a LEFT JOIN