CREATE VIEW HOSP_MEDICATION_INFO ASselect yp.bm MDCID,yp.mc as MDCNAME,jx.mc INJECTTYPE,yp.gg SPECIFICATIONS,BZDW PACKAGEUNIT, JLDW MDCDOSAGEUNIT ,'*' MANUFACTURER, 1 MDCPRICE, JL AS DOSAGE,yLDW AS DOSAGEUNIT,case when LB.BM=2 THEN 2 WHEN LB.BM=4 THEN 1 when LB.BM IN (3,10) THEN 3 ELSE 4 END AS MDCCATEGORY,case when yp.mc like '%头孢%' then 1 else 0 end as ISANTI,0 as ISINJECT,0 as ISBASEDRUG,0 as ISPROVDRUG, 0 as ISCITYDRUG, case when LB.BM IN (3,10) then 1 else 0 end as ISCHINESEPATENTDRUG, case when LB.BM=4 then 1 else 0 end as ISCHINESEMEDICINE , case when LB.BM =11 then 1 else 0 end as ISPREPARATION, 1 as ANTIGRADE, null as MODIFYTIME,0 as ISHEALINSURDRUG,0 as ISASSISTDRUG,0 as ISDISABLE,'123456' as HOSPID,'','','',nullfrom HIS.ZD_YP yp left join HIS.ZD_YPTJLb lb on yp.tjlb=lb.bmleft join HIS.ZD_YPJX jx on yp.jx=jx.bm
'123456' AS HOSPID , '' , '' , '' , NULL FROM HIS.ZD_YP yp后面的几个列好像没指定列名 '123456' AS HOSPID , '' AS a, '' AS b, '' AS c, NULL AS d FROM HIS.ZD_YP yp这样试试
0 as ISCITYDRUG,
case when LB.BM IN (3,10) then 1 else 0 end as ISCHINESEPATENTDRUG,
case when LB.BM=4 then 1 else 0 end as ISCHINESEMEDICINE ,
case when LB.BM =11 then 1 else 0 end as ISPREPARATION,
1 as ANTIGRADE,
null as MODIFYTIME,0 as ISHEALINSURDRUG,0 as ISASSISTDRUG,0 as ISDISABLE,'123456' as HOSPID,'','','',nullfrom HIS.ZD_YP yp left join
HIS.ZD_YPTJLb lb on yp.tjlb=lb.bmleft join HIS.ZD_YPJX jx on yp.jx=jx.bm
'123456' AS HOSPID ,
'' ,
'' ,
'' ,
NULL
FROM HIS.ZD_YP yp后面的几个列好像没指定列名
'123456' AS HOSPID ,
'' AS a,
'' AS b,
'' AS c,
NULL AS d
FROM HIS.ZD_YP yp这样试试