Create view with Order By

G'day all,

This statement works fine:
SELECT * FROM MYTABLE ORDER BY MYCOLUMN; But this does not:
CREATE VIEW TEMP AS SELECT * FROM MYTABLE ORDER BY MYCOLUMN; If ORDER BY cannot be used when creating a view, is there a solution.

Thankyou

Neil Moseley Received on Tue Apr 13 1999 - 09:59:39 CDT