essage -- any
ideas on how to fix this?
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
At 12:53 PM 1/13/200
Hello all, my first mysql posting. I've been a Sybase SQL Server
programmer for
10 years and the following select I know I have to translate as MySQL does not
support nested selects.
My version:
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
insert h2
select w.word,' ', 0
from