I have created a simple insert query to move the contents of table A into table B (there is some additions made in this process).
INSERT INTO TABLE B (Col A, Col B, Col C, Col D)
SELECT Col A, Col B, Col C,'Fixed' FROM TABLE A
However, this scrambles the order of the rows. The order is important because it represents a parent-child relationship. What do I need to change to maintain the row order?