unable to get not exists left join to work--please help

2002-01-13 Thread Roleigh Martin
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

Re: unable to get not exists left join to work--please help

2002-01-13 Thread Roleigh Martin
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