I would like to understand why the left join does not react as in mysql. I have two tables that I would like to put together.
This is the statement that works for me in mysql:
SELECT * from EtlStep LEFT JOIN EtlStepExecution on EtlStep.Id = EtlStepExecution.StepId where EtlStep.PackageId = 2000000 AND (EtlStepExecution.PackageExecutionId = 3000014 OR EtlStepExecution.StepId is null);
The same statement does not output the one line where the StepId is null
That is the output of mysql
And this is the output in memsql
The line with the id 2000018 is not displayed.
I’d be happy if you could help me.