数据库在第一次插入数据后,两个字段值是为空的,因为是流程到第二步第三步才往里面添加数据的,但是这样,就无法select出数据来了:
S ELECT d.Name AS '填写部门', c.Name AS '填写人', a.WriteDate AS '填写时间', a.LSH AS '流水号', e.ZMC AS '值类别', a.jymc AS '检验名称',a.PIHAO AS '批号', a.qysj AS '取样时间', f.Name AS '取样人', a.SFLY AS '是否留样', a.LYBH AS '留样编号', a.COA AS '成品COA编号', a.JYBZYJ AS '检验标准依据', a.CSJG AS '测试结果', g.DW AS '单位', a.jd AS '校对', h.Name AS '校对人', a.JDSJ AS '校对时间', a.SH AS '审核', i.Name AS '审核人', a.SHSJ AS '审核时间' F ROM dbo.T_PG_PZJYB a JOIN tXTDM b ON a.JYLB = b.IBM JOIN dbo.tUser c ON a.WriteMan = c.ID JOIN dbo.lbOrganization d ON a.WriteDept = d.ID JOIN T_PZ_ZLBB e ON a.ZLB = e.ID JOIN tuser f ON a.qyr = f.ID JOIN T_PZ_JLDWB g ON a.dw = g.ID JOIN dbo.tUser h ON a.jdr = h.ID JOIN dbo.tUser i ON a.SHR = i.ID W HERE B.FLDM = 'JYLB' AND a.JYLB = 2
|