I still say use ORDER BY. It does not matter that you are joining tables, it will still work consistently.

Even if (by a small miracle) somebody here knows why the APEX grid does not sort the same as MS Access, and VB sorts different than the other two, you'll probably end up in the same boat anyway.

Just my 2 cents worth.

Anyone else? I'm sure my answer is not satisfactory to Michael.