像这种语句
select a.* from (select ab.*,(SELECT count(1) FROM (SELECT ehr_id FROM Maternal_Health t1 WHERE enable_flag=1 AND to_number(to_char(visit_date,'yyyy'))=2013AND
EXISTS(SELECT 1 FROM info e,ws_region t WHERE e.ehr_id=t1.ehr_id AND e.region_id=t.parent_id AND e.town_id=t.region_id AND visit_level<3) GROUP BY ehr_id
HAVING count(1)>=5) c) maternal_num, FROM ws_region t
)ab )a
这里提示,找不到t.region_id我该怎么解决。我自己尝试了下把 ws_region t这句话加到from info,ws_region 后面,这样是解决了。可是数据不对,为什么会这样?小弟菜鸟一只!还望大神们!教教,小弟分不多,还望大神别嫌分少
select a.* from (select ab.*,(SELECT count(1) FROM (SELECT ehr_id FROM Maternal_Health t1 WHERE enable_flag=1 AND to_number(to_char(visit_date,'yyyy'))=2013AND
EXISTS(SELECT 1 FROM info e,ws_region t WHERE e.ehr_id=t1.ehr_id AND e.region_id=t.parent_id AND e.town_id=t.region_id AND visit_level<3) GROUP BY ehr_id
HAVING count(1)>=5) c) maternal_num, FROM ws_region t
)ab )a
这里提示,找不到t.region_id我该怎么解决。我自己尝试了下把 ws_region t这句话加到from info,ws_region 后面,这样是解决了。可是数据不对,为什么会这样?小弟菜鸟一只!还望大神们!教教,小弟分不多,还望大神别嫌分少
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货