SELECT TD.DEPT_CODE,
TD.DEPT_NAME,
TOR.ORDER_NO,
TC.CUST_CODE,
TC.CUST_NAME,
TOR.ORDER_AMT

FROM TBL_ORDERS AS TOR

INNER JOIN TBL_DEPT AS TD
 ON TOR.DEPT_CODE = TD.DEPT_CODE
 
LEFT OUTER JOIN TBL_CUST AS TC
 ON TOR.CUST_CODE =TC.CUST_CODE
 
 ORDER BY  TOR.DEPT_CODE ASC,TOR.ORDER_NO ASC;