SELECT JXC_YJ_XZWZ.CLMC AS Material Name, JXC_YJ_XZWZ.GGXH AS Specification Model,
CAST (jxc_yj_xzwz.sl as int) AS number, isnull (SCDWBMK.DWMC, '') AS department,
Case JXC_YJ_XZWZ.SYQK WHEN '0' TEN 'Using' Else 'uses' end as usage, Substring (varchar, jxc_yj_xzwz.r, 20), 1, 10) AS manufacturing date,
JXC_YJ_XZWZ.ZDR AS Bank, JXC_YJ_XZWZ.BZ AS Remarks
From JXC_YJ_XZWZ LEFT OUTER JOIN
SCDWBMK ON JXC_YJ_XZWZ.BMBM = SCDWBMK.DWBM
