As some may know, the SQL COALESCE statement will replace any nulls it finds with some other value. This function is a rock and staple of coding in SQL. It is similar to the ISNULL SQL function except it returns the non-null value instead of a boolean without having to write an “if” statement, and is extremely useful in “SELECT” […]
Here is a picture that one of my buds sent me. It explains SQL joins to me better than just about anything I’ve seen in the textbooks. Hope it helps.