select SALES_DATE as SAL_DATE, SALES.SALES_NO as NO, ITEM_CODE, SALES_QTY as SAL_QTY, DELIVERED_QTY as DEL_QTY
from SALES left JOIN SALES_DTL on SALES.SALES_NO = SALES_DTL.SALES_NO
where SALES_DATE BETWEEN '2024-04-01' AND '2024-04-10'
order by SALES_DATE DESC, SALES.SALES_NO, ITEM_CODE;