oracle数据库关联查询的sql问题!!!!
有如下ST_WLAN_CPUSR_CNT_D表和ST_WLAN_RDS_CPUSR_INFO_D表:
create table ST_WLAN_CPUSR_CNT_D (
DATE8 VARCHAR2(8),
HOSTNAME VARCHAR2(20),
USERCITY VARCHAR2(20),
SUM_REGUSRCNT NUMBER,
SUM_ACTUSRCNT NUMBER
);
create table ST_WLAN_RDS_CPUSR_INFO_D(
DATE8 VARCHAR2(8),
HOSTNAME VARCHAR2(20),
ACIP VARCHAR2(20),
SUM_USERDT NUMBER,
SUM_USERTHP NUMBER
);
------解决方案--------------------为什么要用full join来连接啊?当然多了很多啦
换一种连接吧
------解决方案--------------------内联接inner join