--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/UnitTests/Linq/ProviderSpecific/Access.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,33 @@
+using System;
+
+using NUnit.Framework;
+
+using BLToolkit.Data.DataProvider;
+
+namespace Data.Linq.ProviderSpecific
+{
+	[TestFixture]
+	public class Access : TestBase
+	{
+		[Test]
+		public void SqlTest()
+		{
+			using (var db = new TestDbManager(ProviderName.Access))
+			{
+				var res = db
+					.SetCommand(@"
+						UPDATE
+							[Child] [c]
+								LEFT JOIN [Parent] [t1] ON [c].[ParentID] = [t1].[ParentID]
+						SET
+							[ChildID] = @id
+						WHERE
+							[c].[ChildID] = @id1 AND [t1].[Value1] = 1
+",
+						db.Parameter("@id1", 1001),
+						db.Parameter("@id", 1002))
+					.ExecuteNonQuery();
+			}
+		}
+	}
+}