I would like update the column [ACIdent] from the table [Values]. With the subquery i try to get an ID from the same table. On the point ??? i try to access to the column [PathName] of the respective row of the update script. But this solution doesn’t work. How can i do this? Many thanks in advance! Answer Restructure