[EMAIL PROTECTED] wrote: ... > I didn't realise that a join will automatically order it too! > I guess that > makes sense. Unfortunately, I need the ordering done by > Upper case - for > next version I will add UpperTitle and UpperName columns that are > automatically updated, but I'm stuck without them at the moment. ...
Yes, there is, with the current implementation, not necessarily with the new implementation mentioned by Holger, some ordering. But you cannot be sure that this ordering will be the same all the time- It depends on the sequence, the tables are joined. If this sequence will change for some reason, then the ordering will not be the same as it is now. And, do I understand correctly, that you think about adding two new columns to a table to get rid of the upper in the order by-clause of this select? We learned, that the table is a small one, then it is no problem of needed additional space. But with a 'normal' table of several thousand or million entries that would be a strange idea. And the need to update (with trigger) these added columns is another point, I would not like just for avoiding this upper. And on the other hand: So far, the join-result will be build physically anyway, as I told you, the ordering may change if not specified with an order-by-clause, so adding this ORDER BY UPPER(..) is not that bad as it could be (with a single-table-select with no need to build the result physically anyway). Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
