SELECT *,(SELECT AMT AS '110_A' FROM IMMIGRATION AS A WHERE A.PORT_CODE = B.PORT_CODE AND A.KIND_CODE = '110') AS '差分'
FROM IMMIGRATION AS B
INNER JOIN PORT 
ON PORT.PORT_CODE = B.PORT_CODE 
WHERE B.GROUP_CODE = 120
ORDER BY B.PORT_CODE;