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
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/2002, Roleigh Martin wrote:
Hello all, my first mysql posting. I've been