insert query problem

INSERT INTO TABLE1
        (COL1,COL2,COL3)
(SELECT
    COL1, COL2, COL3
FROM TABLE2
ORDER BY PRIMARY_KEY_COL) TABLE1 HAS A BEFORE INSERT TRIGGER THAT INSERTS PRIMARY KEY USING A SEQUENCE
HOWEVER THE INSERT ORDER APPEARS TOTALLY RANDOM EVEN THOUGH I ADDED AN ORDER BY CLAUSE. IE TABLE 2 FIRST RECORD MIGHT BE 40TH RECORD IN TABLE 1 RATHER THAN FIRST RECORD. ANYONE KNOW WHAT THE PROBLEM IS? THANKS
PETER Received on Mon Mar 29 1999 - 16:14:57 CST