I need to populate some Data Extension using another Data Extension that contains all the accounts data. I want to attach a new column and the value for that column should be randomized from another Data Extension that contains some data. I've encountered a problem with putting the randomized value as an additional column - it randomizes the value but it puts the same value for all the records. I want to randomize different values for different records.

Table example with values that should be randomized:

Table name: Newsletter subscribers - data

and here is my SQL query:

SELECT *,
(SELECT TOP 1 value FROM [Newsletter subscribers - data] ORDER BY NEWID()) AS Content

FROM [Account]

I've tried also ORDER BY RAND() but it doesn't work as well...