select from 3 tables one is empty code example

Example: select from 3 tables one is empty

Replacing "JOIN", which implies "INNER JOIN", by "LEFT JOIN" should do the trick.