select 
--SALES.SALES_DATE as SAL_DATE,
alter table SALES add SHIP_STS integer
--SALES.SALES_NO as NO,
--SALES_DTL.ITEM_CODE as ITEM_CODE,
--SALES_DTL.SALES_QTY as SAL_QTY,
--SALES_DTL.DELIVERED_QTY as DEL_QTY
from SALES
--inner join SALES_DTL 
--on SALES.SALES_NO = SALES_DTL.SALES_NO
--order by SALES.SALES_DATE desc,
--SALES.SALES_NO asc,
--SALES_DTL.ITEM_CODE asc