SQL 去重合并两张表记录并统一字段名

以下是根据题目要求编写的SQL语句：

SELECT HOST_IP, HOST_PORT, USER_NAME, PASSWORD, HOST_STATE
FROM (
  SELECT HOST_IP, HOST_PORT, USER_NAME, PASSWORD, HOST_STATE
  FROM A
  UNION ALL
  SELECT HOST_IP, connect_port AS HOST_PORT, user_name AS USER_NAME, login_password AS PASSWORD, host_state AS HOST_STATE
  FROM B
) AS temp
GROUP BY HOST_IP

上述SQL语句中，首先使用UNION ALL将A表和B表中的记录合并在一起，然后使用GROUP BY HOST_IP对结果进行分组，以去除重复的HOST_IP。最后选择需要的字段，并使用统一的字段名进行返回。