update problem?

[wxdqz]

Hi,

Have anyone recogize why my mysql code didnt work? Code below?

mysql> UPDATE GO, SGD SET GO.G1=SGD.G1, GO.G2=SGD.G2 WHERE GO.G3 = SGD.G3;

Errors generated like

ERROR 1064: You have an error in your SQL syntax near ' SGD SET GO.Gene=SGD.Gene, GO.GeneID=SGD.GeneID WHERE GoNum = SGD.GoNum'
at line 1

Thanks a lot

Hui