Index: Ringtoets/Common/test/Ringtoets.Common.IO.Test/SoilProfile/SoilDatabaseQueryBuilderTest.cs
===================================================================
diff -u -rde21ac76368ff1ca60806c5de4aa06420a9a8b1c -r6379e5b1f8fd510f54137ceed602bd2900cdf235
--- Ringtoets/Common/test/Ringtoets.Common.IO.Test/SoilProfile/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision de21ac76368ff1ca60806c5de4aa06420a9a8b1c)
+++ Ringtoets/Common/test/Ringtoets.Common.IO.Test/SoilProfile/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 6379e5b1f8fd510f54137ceed602bd2900cdf235)
@@ -67,5 +67,21 @@
                                          "WHERE Probability NOT BETWEEN 0 AND 1 OR Probability ISNULL;";
             Assert.AreEqual(expectedQuery, query);
         }
+
+        [Test]
+        public void GetStochasticSoilModelOfMechanismQuery_Always_ReturnsExpectedValues()
+        {
+            // Call
+            string query = SoilDatabaseQueryBuilder.GetStochasticSoilModelOfMechanismQuery();
+
+            // Assert
+            const string expectedQuery = @"SELECT M.ME_Name, SP.XWorld, SP.YWorld, S.SE_Name, SSM.SSM_Name, SSM.SSM_ID " +
+                                         "FROM Mechanism M " +
+                                         "INNER JOIN Segment S USING(ME_ID) " +
+                                         "INNER JOIN StochasticSoilModel SSM USING(SSM_ID) " +
+                                         "INNER JOIN SegmentPoints SP USING(SE_ID) " +
+                                         "ORDER BY M.ME_Name, SSM.SSM_ID;";
+            Assert.AreEqual(expectedQuery, query);
+        }
     }
 }
\ No newline at end of file