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 td.dept_code = tor.dept_code
left outer join tbl_cust as tc on tc.cust_code = tor.cust_code
order by tor.dept_code, tor.order_no;