Strict Match on Many-to-One Relationships in Lookup Tables Using SQL

Eliminating Duplicate Rows with Null Values Using the WITH Clause