SELECT * from MS_SFMX,MS_MZXX WHERE MS_SFMX.MZXH = MS_MZXX.MZXH and MS_MZXX.JGID = 1 and MS_MZXX.JZRQ is null and MS_MZXX.MZLB = 1 and MS_MZXX.YQSB = 1 and MS_MZXX.CZGH = ‘8888‘ and MS_MZXX.SFFS = 0 上面是门诊个人汇总的信息，
SELECT * from MS_SFMX,MS_MZXX
WHERE MS_SFMX.MZXH = MS_MZXX.MZXH and MS_MZXX.JGID = 1 and MS_MZXX.JZRQ
is null and MS_MZXX.MZLB = 1 and MS_MZXX.YQSB = 1 and MS_MZXX.CZGH = ‘8888‘
and MS_MZXX.SFFS = 0
上面是门诊个人汇总的信息，里面是疫苗费是门诊收款处收疫苗费产生的，
SELECT * from MS_SFMX,MS_MZXX
WHERE MS_SFMX.MZXH = MS_MZXX.MZXH and MS_MZXX.JGID = 1 and MS_MZXX.JZRQ
is null and MS_MZXX.MZLB = 1 and MS_MZXX.YQSB = 1 and MS_MZXX.CZGH = ‘8888‘
and MS_MZXX.SFFS = 0
----上面有疫苗费1161，个人账,1011，也就说1101是扣掉就诊卡里面的钱，150是现金