🪲 INNER join doesn't always eliminate nulls

[joocer]

Thank you for taking the time to report a problem with Opteryx.

To help us to respond to your request we ask that you try to provide the below detail about the bug.

Describe the bug A clear and specific description of what the bug is. What the error, incorrect or unexpected behaviour was.

Expected behaviour A clear and concise description of what you expected to happen.

Sample Code/Statement If you can, please submit the SQL statement or Python code snippet, or a representative example using the sample datasets.

Additional context Add any other context about the problem here, for example what you have done to try to diagnose or workaround the problem.