22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT R.TableID, R.TableNumber, R.SampNo, C.Design, C.KZ_Design, NULL AS Expr1, S.Cement, S.Grit, NULL AS Expr2, NULL AS StoneDiameter, S.Water, S.DecWater,
S.Coal, S.Other, NULL AS OtherEx, R.UseArea, R.proj_id, R.UnitID, R.UnitName, R.RecordID, R.CheckDate, C.CementSign, C.GritDiameter, NULL AS Stone1Diameter, NULL AS Expr3,
C.DecWaterType, C.CoalGrade, C.OtherType, NULL AS OtherTypeEx, C.OtherName, NULL AS OtherNameEx, '大石' AS BigStoneName, '小石' AS SmallStoneName, NULL AS GritRatio, S.Cubage, S.LandSlide,
NULL AS Ya3d, NULL AS Yz3d, T.Ya AS Ya7d, T.Yz AS Yz7d, E.Ya AS Ya28d, E.Yz, CASE WHEN C.LandSlideMethod = 0 THEN '(mm)' ELSE '(S)' END AS LandSlideEx
FROM dbo.CementTest31 AS C INNER JOIN
dbo.TableRecord AS R ON R.TableID = 35331 AND C.SelfID = R.RecordID AND (ISNULL(R.IsDel,0) <> 1) INNER JOIN
dbo.CementTest31S AS S ON C.SelfID = S.JoinID AND C.SelNo = S.ToneNo LEFT OUTER JOIN
(SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.CementTest32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1
UNION
SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.JGJ70_90_32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1
UNION
SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.JGJT70_2009_32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1
UNION
SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.JGJT98_2010_32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1) AS T ON T.RecordID = C.SelfID AND T.ToneNo = C.SelNo AND T.AgeDay = 7 LEFT OUTER JOIN
(SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.CementTest32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1
UNION
SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.JGJ70_90_32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1
UNION
SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.JGJT70_2009_32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1
UNION
SELECT Ya, Yz, T1.RecordID, ToneNo, AgeDay FROM dbo.JGJT98_2010_32 T1
INNER JOIN dbo.TableRecord R1 ON T1.SelfID = R1.RecordID AND R1.IsDel <> 1) AS E ON E.RecordID = C.SelfID AND E.ToneNo = C.SelNo AND E.AgeDay = 28