SELECT ALL guiUniqueID, chvCollectionKey, chvCaption, chvClassLibrary, chvClassName, chvParentNode, inyNodeLevel, insNodeSequence, inyNodePlacement, bitExternalProcess, dtmCreated, chvCreator, dtmUpdated, chvUpdater FROM Control.TreeViewNodes ORDER BY inyNodeLevel, insNodeSequenceWhen I execute the code in the View Designer, all is well. However, when I execute the view from either a query or by right-clicking the view name and choosing Open View, the ORDER BY clause does not function correctly. I get the correct quantity and selection of rows that I expect -- they're just not in the correct order.