多个查询同一表但列不同
我试图从两个不同的表中得到更多的汇总结果的列SET@start_res=0301;SET@finish_res=0501;SET@finish_check=0801;SET@start_check=0301;SET@daily_hos=3;SELECT*from
(SELECTCOUNT(DAY_IN)ASarrFROMt_hospitalWHEREDAY_INbetween@start_checkand@finish_checkandRES_DATEbetween@start_resand
@finish_resandID_daily_hos=@daily_hosgroupbyDAY_IN)e,
(SELECTCOUNT(PAT_STATUS)ASONG1FROMt_hospitalWHEREPAT_STATUSlike'%ong%'andDAY_INbetween@start_checkand@finish_check
andRES_DATEbetween@start_resand@finish_resandID_daily_hos=@daily_hosgroupbyDAY_IN)a,
(SELECTCOUNT(PAT_STATUS)ASRTEDFROMt_hospitalWHEREPAT_STATUSlike'%rtde%'andDAY_INbetween@start_checkand@finish
_checkandRES_DATEbetween@start_resand@finish_resandID_daily_hos=@daily_hosgroupbyDAY_IN)b,
(SELECTCOUNT(PAT_STATUS)ASPOLIFROMt_hospitalWHEREPAT_STATUSlike'%pol%'andDAY_INbetween@start_checkand@finish_
checkandRES_DATEbetween@start_resand@finish_resandID_daily_hos=@daily_hosgroupbyDAY_IN)c,
(SELECTCOUNT(PAT_STATUS)ASparaFROMt_hospitalWHEREPAT_STATUSlike'%para%'andDAY_INbetween@start_checkand
@finish_checkandRES_DATEbetween@start_resand@finish_resandID_daily_hos=@daily_hosgroupbyDAY_IN)d
当然,它不能工作,只有第一个显示的列(Arr)工作,而其他列显示一个错误的输出。
我哪里错了?