Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.1_17.2.sql =================================================================== diff -u -r99f60b3252ff2b7e79b482f4c0ac0099914b9928 -rc1ed7c2c08607f068dec05a7aee55c824c764f4f --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.1_17.2.sql (.../Migration_17.1_17.2.sql) (revision 99f60b3252ff2b7e79b482f4c0ac0099914b9928) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.1_17.2.sql (.../Migration_17.1_17.2.sql) (revision c1ed7c2c08607f068dec05a7aee55c824c764f4f) @@ -397,10 +397,11 @@ [StrengthStabilityPointConstructionFailureMechanismMetaEntityId], [FailureMechanismEntityId], [N], - CASE WHEN COUNT([ForeshoreProfileEntityId]) THEN "Onbekend" ELSE NULL END + CASE WHEN COUNT([ForeshoreProfileEntityId]) THEN "Onbekend" ELSE NULL END, CASE WHEN COUNT([StabilityPointStructureEntityId]) THEN "Onbekend" ELSE NULL END FROM [SOURCEPROJECT].StabilityPointStructuresFailureMechanismMetaEntity LEFT JOIN [SOURCEPROJECT].ForeshoreProfileEntity USING (FailureMechanismEntityId) + LEFT JOIN StabilityPointStructureEntity USING (FailureMechanismEntityId) GROUP BY FailureMechanismEntityId; INSERT INTO StabilityPointStructuresOutputEntity SELECT * FROM [SOURCEPROJECT].StabilityPointStructuresOutputEntity; INSERT INTO StabilityPointStructuresSectionResultEntity SELECT * FROM [SOURCEPROJECT].StabilityPointStructuresSectionResultEntity;