How to join MySQL tables using a nullable column?

July 22, 2023 by Tarik

Use the NULL-safe equal operator:

SELECT * FROM A JOIN B ON A.C <=> B.C