<p>In a table I have the following schema</p>

<pre><code>table1:
playerID int primary key,
nationalities nvarchar

table2:
playerID int,
pubVisited nvarchar
</code></pre>

<p>Now, I want to set all the players' playedVisited to null, for player whose nationality is "England", any idea on how to do this? </p>

Judging by the
nvarchar
type, you're using MSSQL. Now, in MySQL you could use a subselect in the update .. where clause but MSSQL has its own update .. from clause:
```
```
UPDATE table2
SET
    table2.pubVisited = null
FROM table1
WHERE
    table2.playerID = table1.playerID and table1.nationalities = 'England'
```
```
Haven't tested it though, so it might not work.