Re: ordinamento di un recordset su due tabelle
[Annoyingly] You cannot use a field's Alias in the order by clause.
Either order by the whole expression that you select as "diff":
order by (cliente.idpass-((CURDATE()-giro.giornopassaggio))) ;
or, more simply, order by the ordinal column
number in which "diff" appears in the select list:
order by 5 ;
Regards, Phill W.
Subject
Written By
Posted
Re: ordinamento di un recordset su due tabelle
July 07, 2023 08:32AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.