'Return random value for each row from different table

I'm trying to get random name for each row, but it just shows same random value for every row. What am I missing?

SELECT TOP (1000)  v.id,v.[Name], RandomName 
FROM [V3_Priva].[dbo].[Vehicle] v
cross join
(Select top 1 ISNULL([Description_cs-CZ], [Description]) RandomName
from crm.Enumeration e
join crm.EnumerationType et on e.EnumerationType_FK = et.Id
where  EnumerationType_FK = 12
order by NEWID()) RandomName

Result table



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source