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 ``` | id | value | |----|--------------| | 1 | media | | 2 | internet | | 3 | life | 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...