I am using SQL Server 2008, and trying to run the following query in management studio:

```
        UPDATE
        Table1 as T1 INNER JOIN Table2 as T2 ON T1.ID=T2.ID
        SET T1.SomeValue = T2.SomeValue

        GO

```

Doesn't work though. Is this sort of thing supported?

Karl

[EDIT]
Let me just be more clear, I wan't to do something like:

```
        UPDATE
        Table1 as T1 INNER JOIN Table2 as T2 ON T1.ID=T2.ID
        SET T1.SomeValue = T2.SomeValue
        T1.SomeValue2 = T2.SomeValue2
        T1.SomeValue3 = T2.SomeValue3
        T1.SomeValue4 = T2.SomeValue4

        GO

```

i.e. without having to explicitly do T1.SomeValue = SELECT..., T2.SomeValue = SELECT...