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

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

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