select count(distinct T_BUYER.ORG_ID||T_BUYER.ORG_NAME) from HIS_HI_INSTORE,T_BUYER where HIS_HI_INSTORE.BUYER_ID=T_BUYER.ORG_ID and HIS_HI_INSTORE.USE_FLAG=0
不过感觉你的T_BUYER.ORG_ID应该是T_BUYER表的主键吧?
那么就直接用
select count(distinct T_BUYER.ORG_ID) from HIS_HI_INSTORE,T_BUYER where HIS_HI_INSTORE.BUYER_ID=T_BUYER.ORG_ID and HIS_HI_INSTORE.USE_FLAG=0
就可以了。
或者利用子查询
select count(*) from
( select distinct T_BUYER.ORG_ID,T_BUYER.ORG_NAME from HIS_HI_INSTORE,T_BUYER where HIS_HI_INSTORE.BUYER_ID=T_BUYER.ORG_ID and HIS_HI_INSTORE.USE_FLAG=0 )
不过感觉你的T_BUYER.ORG_ID应该是T_BUYER表的主键吧?
那么就直接用
select count(distinct T_BUYER.ORG_ID) from HIS_HI_INSTORE,T_BUYER where HIS_HI_INSTORE.BUYER_ID=T_BUYER.ORG_ID and HIS_HI_INSTORE.USE_FLAG=0
就可以了。
或者利用子查询
select count(*) from
( select distinct T_BUYER.ORG_ID,T_BUYER.ORG_NAME from HIS_HI_INSTORE,T_BUYER where HIS_HI_INSTORE.BUYER_ID=T_BUYER.ORG_ID and HIS_HI_INSTORE.USE_FLAG=0 )
group by T_BUYER.ORG_ID,T_BUYER.ORG_NAME
(select distinct T_BUYER.ORG_ID,T_BUYER.ORG_NAME from HIS_HI_INSTORE,T_BUYER where HIS_HI_INSTORE.BUYER_ID=T_BUYER.ORG_ID and HIS_HI_INSTORE.USE_FLAG=0
)