Re: When using Memory Storage Join ON Clause would not work anymore

[Rick James]

Please provide
SHOW CREATE TABLE iprooptions

It seems like you could get rid of the NOT NULL tests if you changed LEFT JOINs to plain JOINs.

> My Problem is, when I now surround this select with a Create Temporary Table tmp Enginge=Memory

Let's see the entire statement; perhaps there is some subtle problem in the syntax or spelling.

> Don't matter about the Select please.

Sometimes cleaning up the code makes the problem go away!