上面那个 错的
select cuih.RECORD_NO,cmbi.WATER_METER_CALIBRE,cumi.INSTALL_AREAS,bw.MOVETABLE_DATE,bw.EXECUTOR,
case
when bw.PRIMARY_USER_INFO_ID = cuih.id then cuih.USER_NAME end,
case
when bw.PRIMARY_USER_INFO_ID = cuih.id then cuih.USER_ADDRESS end,
case
when bw.NEW_USER_INFO_ID = cuih.id then cuih.USER_NAME end,
case
when bw.NEW_USER_INFO_ID = cuih.id then cuih.USER_ADDRESS end,
case
when bw.NEW_USER_INFO_ID = cuih.id then cuih.USER_PHONE end
from BW_TRANSFER bw,CHARGE_USER_INFO_HISTORY cuih,
CHARGE_METER_BASE_INFO cmbi,CHARGE_USER_METER_INFO_HISTORY cumi
where cumi.METER_NO = cmbi.SEAL_NO
and cuih.record_no = cumi.record_no
这个有循环 多次显示不需要的