我有两个这样的选择查询:
SELECT COUNT(WARD_id)
FROM IP_Admission
WHERE (Status = 'V' OR Status = 'D') AND WARD_ID = 1
SELECT BED_STRENGTH
FROM Ward_Master
WHERE Ward_ID = 1
查询的输出是
2
6
现在我需要回答4。任何帮助表示赞赏。
select count(i.ward_id) - w.bed_strength as Diff from
ip_admission i join ward_master w on w.ward_id=i.ward_id
where (status='V' or status='D') and i.ward_id=1
group by w.bed_strength
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句