Index: Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs
===================================================================
diff -u -r86e6bb44ba1ccbec534f3fcf379481ea8d45d67f -r64c21c2c91a3cef9df279e58efda8e45a9d598f7
--- Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 86e6bb44ba1ccbec534f3fcf379481ea8d45d67f)
+++ Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 64c21c2c91a3cef9df279e58efda8e45a9d598f7)
@@ -64,11 +64,12 @@
         public void GetStochasticSoilModelOfMechanismCountQuery_Always_ReturnsExpectedValues()
         {
             // Setup
-            const string expectedQuery = "SELECT COUNT('1') AS nrOfRows " +
-                                         "FROM Mechanism M " +
+            const string expectedQuery = "SELECT COUNT('1') AS nrOfRows FROM (" +
+                                         "SELECT '1' FROM Mechanism M " +
                                          "INNER JOIN Segment S USING(ME_ID) " +
                                          "INNER JOIN StochasticSoilModel SSM USING(SSM_ID) " +
-                                         "WHERE M.ME_Name = @ME_Name;";
+                                         "INNER JOIN SegmentPoints SP USING(SE_ID) " +
+                                         "WHERE M.ME_Name = @ME_Name GROUP BY SSM_ID);";
 
             // Call
             string query = SoilDatabaseQueryBuilder.GetStochasticSoilModelOfMechanismCountQuery();