select dept.DEPT_CODE,DEPT_NAME,ORDER_NO,cust.CUST_CODE,CUST_NAME,ORDER_AMT
from TBL_ORDERS as ord
inner join  TBL_DEPT as dept
on ord.DEPT_CODE = dept.DEPT_CODE
left outer join TBL_CUST as cust
on ord.DEPT_CODE = dept.DEPT_CODE
order by ord.DEPT_CODE asc,ord.ORDER_NO;