* Roleigh Martin
> -> from words w, events e, LEFT JOIN events e2 on ( e.url_id =
Try removing a comma:
from words w, events e LEFT JOIN events e2 on ( e.url_id =
The comma is actually a 'synonym' for 'INNER JOIN', the statement fraction
above is the same as:
from words w INNER JOIN e
* Roleigh Martin
> mysql> insert h2
> -> select h1.word, ' ', 0
> -> from h1 left join h2 ah2 on h1.word = ah2.word
> -> where ah2.word is NULL;
> ERROR 1093: INSERT TABLE 'h2' isn't allowed in FROM table list
You can not select from the table you are inserting to. Use a temporary
I am able to get what I want with one workaround but am unable to insert the
selected data into the target table - note below:
mysql> select h1.word, ' ', 0
-> from h1 left join h2 ah2 on h1.word = ah2.word
-> where ah2.word is NULL;
+---+---+---+
| word
