INSERT....SELECT problems

[wxdqz]

Hi,

Why mysql seems to have problems run the simple code?

mysql> insert into GO (G1) select SGD.G1 from SGD where GO.G2 = SGD.G2;
ERROR 1109: Unknown table 'GO' in where clause

or
mysql> INSERT INTO GO ( Gene )SELECT SGD.G1 FROM GO INNER JOIN SGD ON GO.G2 = SGD.G2;
ERROR 1109: Unknown table 'GO' in where clause

But my GO table should be no problem. I can select any field from GO.

Have anyone had ideas?

Thanks,