SELECT D.DEPT_CODE, DEPT_NAME, ORDER_NO, C.CUST_CODE, CUST_NAME, ORDER_AMT
FROM TBL_ORDERS O, TBL_DEPT D, TBL_CUST C
WHERE D.DEPT_CODE = O.DEPT_CODE;