select TBL_DEPT.DEPT_CODE,TBL_DEPT.DEPT_NAME,TBL_CUST.CUST_CODE,
TBL_CUST.CUST_NAME,TBL_ORDERS.ORDER_AMT,TBL_ORDERS.ORDER_NO
from  TBL_DEPT join TBL_ORDERS on TBL_ORDERS.DEPT_CODE = TBL_DEPT.DEPT_CODE left join TBL_CUST on TBL_CUST.CUST_CODE = TBL_ORDERS.CUST_CODE 
ORDER BY TBL_ORDERS.DEPT_CODE ASC, TBL_ORDERS.ORDER_NO;