ALTER TABLE SALES_DTL ADD SHIP_STS VARCHAR(10);

SELECT S.SALES_DATE AS SAL_DATE, S.SALES_NO AS NO, D.ITEM_CODE AS ITEM_CODE, D.SALES_QTY AS SAL_QTY, D.DELIVERED_QTY AS DEL_QTY, D.SHIP_STS AS SHIP_STS
FROM SALES S
JOIN SALES_DTL D ON S.SALES_NO = D.SALES_NO
ORDER BY SAL_DATE DESC, NO ASC, ITEM_CODE ASC;