Vitor Varalonga wrote:
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:
Don't use the ORDER BY clause, it isn't really useful for the INSERT anyway.
Sorry for the somehow off-topic non-zope question, but I would really appreciate if someone could please enlighten on this.
Post these questions on the SAP DB mailing list: http://listserv.sap.com/mailman/listinfo/sapdb.general You can access it also as a newsgroup through gmane: news://news.gmane.org/gmane.comp.db.sapdb.general Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin daniel.dittmar@sap.com http://www.sapdb.org