| Subject | Order By in a Insert statement? |
|---|---|
| Author | Mike Grover |
| Post date | 2002-01-25T15:12:45Z |
This SQL Statemnet works Good:
INSERT INTO MG
SELECT *
FROM KS WHERE ZIP='66873';
But this Doesn't:
INSERT INTO MG
SELECT *
FROM KS WHERE ZIP='66873' ORDER BY 3;
Is this not allowed?
mike
INSERT INTO MG
SELECT *
FROM KS WHERE ZIP='66873';
But this Doesn't:
INSERT INTO MG
SELECT *
FROM KS WHERE ZIP='66873' ORDER BY 3;
Is this not allowed?
mike