用exists 的语句要这样用
要加表名的吧!
select count(*) from c01d
where c01d00='03' and exists (select spbm from md_xx where (mc<>mc_zb or gg<>gg_zb or dw<>dw_zb or sl<>sl_zb or bzl<>bzl_zb or ht<>ht_zb) AND md='03' and spbm=c01d.c01d01)
要加表名的吧!
select count(*) from c01d
where c01d00='03' and exists (select spbm from md_xx where (mc<>mc_zb or gg<>gg_zb or dw<>dw_zb or sl<>sl_zb or bzl<>bzl_zb or ht<>ht_zb) AND md='03' and spbm=c01d.c01d01)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货