جملة استعلام للتعديل اكثر من حقل

الجملة هي :

		SQL_Query = "Update [Table1],[Table2] "
		SQL_Query &= "Set [S_NO2] = [S_NO1] "
		SQL_Query &= " Where [QTY2]=[QTY1] "

والتطبيق هو :

		SQL_Query = "Update [Table1],[Table2] "
		SQL_Query &= "Set [S_NO2] = [S_NO1] "
		SQL_Query &= " Where [QTY2]=[QTY1] "
		Dim MyCommand As New System.Data.OleDb.OleDbCommand(SQL_Query, MyConn)
		MyConn.Open()
		Try
			Dim RecordsAffected As Integer = MyCommand.ExecuteNonQuery()
			If RecordsAffected = 0 Then
				MessageBox.Show("لم يتم تحديث السجلات ")
			Else
				'msgbox "Done
			End If
		Catch ex As Exception
			MsgBox(ex.Message)
		 End Try
		MyConn.Close()