select TBL_DEPT.DEPT_CODE, DEPT_NAME, TBL_ORDERS.ORDER_NO, TBL_CUST.CUST_CODE, TBL_CUST.CUST_NAME, TBL_ORDERS.ORDER_AMT
from TBL_DEPT
join TBL_ORDERS
on TBL_DEPT.DEPT_CODE = TBL_ORDERS.DEPT_CODE
left join TBL_CUST
on TBL_ORDERS.CUST_CODE = TBL_CUST.CUST_CODE 
order by TBL_DEPT.DEPT_CODE asc, TBL_ORDERS.ORDER_NO asc;