select OT.DEPT_CODE, DE.DEPT_NAME, OT.ORDER_NO, OT.CUST_CODE, CU.CUST_NAME, OT.ORDER_AMT
from TBL_ORDERS AS OT
--内部結合
INNER JOIN TBL_DEPT AS DE
ON DE.DEPT_CODE=OT.DEPT_CODE
--外部結合
LEFT OUTER JOIN TBL_CUST AS CU
ON CU.CUST_CODE=OT.CUST_CODE
--昇順
order by OT.DEPT_CODE,OT.ORDER_NO