1 2 3
|
SELECT Nz(Sum([THEO].[1]))-Nz(Sum([Abs].[1])) AS 1, Nz(Sum([THEO].[2]))-Nz(Sum([Abs].[2])) AS 2, Nz(Sum([THEO].[3]))-Nz(Sum([Abs].[3])) AS 3, Nz(Sum([THEO].[4]))-Nz(Sum([Abs].[4])) AS 4, Nz(Sum([THEO].[5]))-Nz(Sum([Abs].[5])) AS 5, Nz(Sum([THEO].[6]))-Nz(Sum([Abs].[6])) AS 6, Nz(Sum([THEO].[7]))-Nz(Sum([Abs].[7])) AS 7, Nz(Sum([THEO].[8]))-Nz(Sum([Abs].[8])) AS 8, Nz(Sum([THEO].[9]))-Nz(Sum([Abs].[9])) AS 9, Nz(Sum([THEO].[10]))-Nz(Sum([Abs].[10])) AS 10, Nz(Sum([THEO].[11]))-Nz(Sum([Abs].[11])) AS 11, Nz(Sum([THEO].[12]))-Nz(Sum([Abs].[12])) AS 12, Nz(Sum([THEO].[13]))-Nz(Sum([Abs].[13])) AS 13, Nz(Sum([THEO].[14]))-Nz(Sum([Abs].[14])) AS 14, Nz(Sum([THEO].[15]))-Nz(Sum([Abs].[15])) AS 15, Nz(Sum([THEO].[16]))-Nz(Sum([Abs].[16])) AS 16, Nz(Sum([THEO].[17]))-Nz(Sum([Abs].[17])) AS 17, Nz(Sum([THEO].[18]))-Nz(Sum([Abs].[18])) AS 18, Nz(Sum([THEO].[19]))-Nz(Sum([Abs].[19])) AS 19, Nz(Sum([THEO].[20]))-Nz(Sum([Abs].[20])) AS 20, Nz(Sum([THEO].[21]))-Nz(Sum([Abs].[21])) AS 21, Nz(Sum([THEO].[22]))-Nz(Sum([Abs].[22])) AS 22, Nz(Sum([THEO].[23]))-Nz(Sum([Abs].[23])) AS 23, Nz(Sum([THEO].[24]))-Nz(Sum([Abs].[24])) AS 24, Nz(Sum([THEO].[25]))-Nz(Sum([Abs].[25])) AS 25, Nz(Sum([THEO].[26]))-Nz(Sum([Abs].[26])) AS 26, Nz(Sum([THEO].[27]))-Nz(Sum([Abs].[27])) AS 27, Nz(Sum([THEO].[28]))-Nz(Sum([Abs].[28])) AS 28, Nz(Sum([THEO].[29]))-Nz(Sum([Abs].[29])) AS 29, Nz(Sum([THEO].[30]))-Nz(Sum([Abs].[30])) AS 30, Nz(Sum([THEO].[31]))-Nz(Sum([Abs].[31])) AS 31
FROM T_MdaJourCopie AS THEO INNER JOIN T_MdaJourCopie2 AS ABS ON (THEO.[A0-SIGLE2] = ABS.[A0-SIGLE2]) AND (THEO.[A0-SIGLE4] = ABS.[A0-SIGLE4]) AND (THEO.[A0-SIGLE3] = ABS.[A0-SIGLE3]) AND (THEO.[A0-SIGLE2] = ABS.[A0-SIGLE2]) AND (THEO.[CO-TYPCTR] = ABS.[CO-TYPCTR]) AND (THEO.[NH-FAMPRO] = ABS.[NH-FAMPRO]) AND (THEO.[NH-POPULO] = ABS.[NH-POPULO]); |
Partager