select TBL_DEPT.DEPT_CODE,TBL_DEPT.DEPT_NAME,TBL_CUST.CUST_CODE,
TBL_CUST.CUST_NAME,TBL_ORDERS.ORDER_AMT
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;