Hi, you can use the INSERT-command with a query, e.g.:
INSERT INTO table1 SELECT col1, col2 FROM table2 WHERE col3 = 'xy' See also http://www.sapdb.org/htmhelp/92/4f687fdcc911d5994600508b6b8b11/content.htm Florian K�rner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Auftrag von Josu� > Maldonado > Gesendet: Dienstag, 4. M�rz 2003 20:30 > An: [EMAIL PROTECTED] > Betreff: Copy records between tables > > > Is there a way to copy all/certain records from one table to > another in the > same database? > > Thanks in advance > > -- > Josu� Maldonado > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
