Double Sort criteria in Query

[kedalenechong]

Hi All

Is it possible to have dual auto sorting criteria in User Defined Query?  Example first sorting by date followed by Document Number?

Kedalene Chong

[fabiobilicki]

Hi

Yes, use Order by.

Exampe

SELECT 
*
FROM ORDR T0 
ORDER BY T0.[DocDate] DESC, T0.[CardCode]

Rgs

Fabio

[kedalenechong]

Thanks will try and let you know