|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
以下SQL 语句在数据库中执行是正确的,但从EXCEL表中连接到数据库,选择相应表并将语句复制到SQL后提示:SQL Query无法以图形表示,是否仍要继续,请问是什么原因select cfh 处方号,
ghxh 挂号序号,
brxm 病人姓名,
czyxm 医师,
gyb_ks.ksmc 科室,
mzzd 诊断
from yfb_ypcf_bf,gyb_ks,gyb_czy
where cfrq>='2017-08-01'
and cfrq<'2017-08-03'
and ysbm=czybm
and yfb_ypcf_bf.ksbm=gyb_ks.ksbm
and(mzzd like '%鼠疫%'
or mzzd like '%霍乱%'
or mzzd like '%肝炎%'
or mzzd like '%甲肝%'
or mzzd like '%乙肝%'
or mzzd like '%丙肝%'
or mzzd like '%戊肝%'
or mzzd like '%肝炎(未分型)%'
or mzzd like '%丁肝%'
or mzzd like '%痢疾%'
or mzzd like '%细菌性痢疾%'
or mzzd like '%阿米巴性痢疾%'
or mzzd like '%伤寒+副伤寒%'
or mzzd like '%伤寒%'
or mzzd like '%副伤寒%'
or mzzd like '%艾滋%'
or mzzd like '%HIV%'
or mzzd like '%淋病%'
or mzzd like '%梅毒%'
or mzzd like '%Ⅰ期梅毒%'
or mzzd like '%Ⅱ期梅毒%'
or mzzd like '%III期梅毒%'
or mzzd like '%胎传梅毒%'
or mzzd like '%隐性梅毒%'
or mzzd like '%脊灰%'
or mzzd like '%麻疹%'
or mzzd like '%百日咳%'
or mzzd like '%白喉%'
or mzzd like '%流脑%'
or mzzd like '%猩红热%'
or mzzd like '%出血热%'
or mzzd like '%狂犬病%'
or mzzd like '%钩体病%'
or mzzd like '%布病%'
or mzzd like '%炭疽%'
or mzzd like '%肺炭疽%'
or mzzd like '%皮肤炭疽%'
or mzzd like '%炭疽(未分型)%'
or mzzd like '%斑疹伤寒%'
or mzzd like '%乙脑%'
or mzzd like '%黑热病%'
or mzzd like '%疟疾%'
or mzzd like '%间日疟%'
or mzzd like '%恶性疟%'
or mzzd like '%疟疾(未分型)%'
or mzzd like '%登革热%'
or mzzd like '%新生儿破伤风%'
or mzzd like '%肺结核%'
or mzzd like '%涂(+)%'
or mzzd like '%菌(-)%'
or mzzd like '%未痰检%'
or mzzd like '%仅培阳%'
or mzzd like '%传染性非典%'
or mzzd like '%血吸虫病%'
or mzzd like '%丝虫病%'
or mzzd like '%包虫病%'
or mzzd like '%麻风病%'
or mzzd like '%流行性感冒%'
or mzzd like '%流行性腮腺炎%'
or mzzd like '%风疹%'
or mzzd like '%结膜炎%'
or mzzd like '%其它感染性腹泻病%'
or mzzd like '%手足口病%'
or mzzd like '%其它疾病%'
or mzzd like '%人感染H7N9禽流感%'
or mzzd like '%其它传染病%'
or mzzd like '%非淋菌性尿道炎%'
or mzzd like '%尖锐湿疣%'
or mzzd like '%生殖器疱疹%'
or mzzd like '%生殖道沙眼衣原体感染%'
or mzzd like '%水痘%'
or mzzd like '%森林脑炎%'
or mzzd like '%结核性胸膜炎%'
or mzzd like '%人感染猪链球菌%'
or mzzd like '%肝吸虫病%'
or mzzd like '%恙虫病%'
or mzzd like '%人粒细胞无形体病%'
or mzzd like '%发热伴血小板减少综合征%'
or mzzd like '%AFP%'
or mzzd like '%中东呼吸综合征(MERS)%'
or mzzd like '%埃博拉出血热%'
or mzzd like '%寨卡病毒病%'
or mzzd like '%不明原因肺炎%'
or mzzd like '%不明原因%'
or mzzd like '%人感染高致病性禽流感%')
union all
select cfh 处方号,
ghxh 挂号序号,
brxm 病人姓名,
czyxm 医师,
gyb_ks.ksmc 科室,
mzzd 诊断
from yfb_ypcf,gyb_ks,gyb_czy
where cfrq>='2017-08-01'
and cfrq<'2017-08-03'
and ysbm=czybm
and yfb_ypcf.ksbm=gyb_ks.ksbm
and(mzzd like '%鼠疫%'
or mzzd like '%霍乱%'
or mzzd like '%肝炎%'
or mzzd like '%甲肝%'
or mzzd like '%乙肝%'
or mzzd like '%丙肝%'
or mzzd like '%戊肝%'
or mzzd like '%肝炎(未分型)%'
or mzzd like '%丁肝%'
or mzzd like '%痢疾%'
or mzzd like '%细菌性痢疾%'
or mzzd like '%阿米巴性痢疾%'
or mzzd like '%伤寒+副伤寒%'
or mzzd like '%伤寒%'
or mzzd like '%副伤寒%'
or mzzd like '%艾滋%'
or mzzd like '%HIV%'
or mzzd like '%淋病%'
or mzzd like '%梅毒%'
or mzzd like '%Ⅰ期梅毒%'
or mzzd like '%Ⅱ期梅毒%'
or mzzd like '%III期梅毒%'
or mzzd like '%胎传梅毒%'
or mzzd like '%隐性梅毒%'
or mzzd like '%脊灰%'
or mzzd like '%麻疹%'
or mzzd like '%百日咳%'
or mzzd like '%白喉%'
or mzzd like '%流脑%'
or mzzd like '%猩红热%'
or mzzd like '%出血热%'
or mzzd like '%狂犬病%'
or mzzd like '%钩体病%'
or mzzd like '%布病%'
or mzzd like '%炭疽%'
or mzzd like '%肺炭疽%'
or mzzd like '%皮肤炭疽%'
or mzzd like '%炭疽(未分型)%'
or mzzd like '%斑疹伤寒%'
or mzzd like '%乙脑%'
or mzzd like '%黑热病%'
or mzzd like '%疟疾%'
or mzzd like '%间日疟%'
or mzzd like '%恶性疟%'
or mzzd like '%疟疾(未分型)%'
or mzzd like '%登革热%'
or mzzd like '%新生儿破伤风%'
or mzzd like '%肺结核%'
or mzzd like '%涂(+)%'
or mzzd like '%菌(-)%'
or mzzd like '%未痰检%'
or mzzd like '%仅培阳%'
or mzzd like '%传染性非典%'
or mzzd like '%血吸虫病%'
or mzzd like '%丝虫病%'
or mzzd like '%包虫病%'
or mzzd like '%麻风病%'
or mzzd like '%流行性感冒%'
or mzzd like '%流行性腮腺炎%'
or mzzd like '%风疹%'
or mzzd like '%结膜炎%'
or mzzd like '%其它感染性腹泻病%'
or mzzd like '%手足口病%'
or mzzd like '%其它疾病%'
or mzzd like '%人感染H7N9禽流感%'
or mzzd like '%其它传染病%'
or mzzd like '%非淋菌性尿道炎%'
or mzzd like '%尖锐湿疣%'
or mzzd like '%生殖器疱疹%'
or mzzd like '%生殖道沙眼衣原体感染%'
or mzzd like '%水痘%'
or mzzd like '%森林脑炎%'
or mzzd like '%结核性胸膜炎%'
or mzzd like '%人感染猪链球菌%'
or mzzd like '%肝吸虫病%'
or mzzd like '%恙虫病%'
or mzzd like '%人粒细胞无形体病%'
or mzzd like '%发热伴血小板减少综合征%'
or mzzd like '%AFP%'
or mzzd like '%中东呼吸综合征(MERS)%'
or mzzd like '%埃博拉出血热%'
or mzzd like '%寨卡病毒病%'
or mzzd like '%不明原因肺炎%'
or mzzd like '%不明原因%'
or mzzd like '%人感染高致病性禽流感%')
|
|