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