select *
--ORDER_DATETIME as ORDER_DATE
--,MEMBER_CODE as CODE
--,OPTOUT_TYPEの値により表示内容を変更 as OPTOUT
from
(select * from EC_ORDERS EC order by ORDER_DATETIME) inner join MEMBER_MST MM on EC.MEMBER_CODE=MM.MEMBER_CODE