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