SELECT dbo.fqhzl.pz, dbo.fqhzl.byl, b.qhzlbylbz,
CASE WHEN b.qhzlbylbz = '<=1.5' THEN CASE WHEN byl <= 1.5 THEN '合格' ELSE '不合格'
END 不匀率标准判定 WHEN b.qhzlbylbz = '<=1.0' THEN CASE WHEN byl <= 1.0 THEN '合格'
ELSE '不合格' END 不匀率标准判定, dbo.fqhzl.scl, b.qhsclbz
FROM dbo.fqhzl LEFT OUTER JOIN
tianlun.dbo.ylpzk b ON dbo.fqhzl.pz = b.ylmc
CASE WHEN b.qhzlbylbz = '<=1.5' THEN CASE WHEN byl <= 1.5 THEN '合格' ELSE '不合格'
END 不匀率标准判定 WHEN b.qhzlbylbz = '<=1.0' THEN CASE WHEN byl <= 1.0 THEN '合格'
ELSE '不合格' END 不匀率标准判定, dbo.fqhzl.scl, b.qhsclbz
FROM dbo.fqhzl LEFT OUTER JOIN
tianlun.dbo.ylpzk b ON dbo.fqhzl.pz = b.ylmc
(CASE WHEN b.qhzlbylbz = '<=1.5' THEN (CASE WHEN byl <= 1.5 THEN '合格' ELSE '不合格'
END) WHEN b.qhzlbylbz = '<=1.0' THEN (CASE WHEN byl <= 1.0 THEN '合格'
ELSE '不合格' END) end) 不匀率标准判定, dbo.fqhzl.scl, b.qhsclbz
FROM dbo.fqhzl LEFT OUTER JOIN
tianlun.dbo.ylpzk b ON dbo.fqhzl.pz = b.ylmc