[Zope] SQL prob on SAPDB

Hi! I need to copy the data from one table to another, on my SAPDB database. If I where working with a SQL Server DB I would run the following query: INSERT INTO TableB (fieldB1, fieldB2) SELECT fieldA1, fieldA2 FROM TableA ORDER BY fieldA1 But it seems that it doesn't work on SAPD, since it returned me the following error message: Database error occured: Native error: -5015 Text: [SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-5015 POS(191) Missing keyword:GROUP,OR,MOD,HAVING,DIV,AND,UPDATE,UNION,REJECT,INTER. Sorry for the somehow off-topic non-zope question, but I would really appreciate if someone could please enlighten on this. kind regards, Vitor Varalonga