title: Selecting random value for every row
body: <p>Suppose I have 2 tables called 'FOR_TEST_1' with column A, B, C and 'FOR_TEST_2' with column D, E, F.</p>
  
  <p>I would like to generate column A paired with a random value from column D.</p>
  
  <p>Here is a snippet of the tables.</p>
  
  <p><a href="https://i.stack.imgur.com/G8Qe8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/G8Qe8.png" alt="Table FOR_TEST_1"></a></p>
  
  <p><a href="https://i.stack.imgur.com/9DxSg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9DxSg.png" alt="Table FOR_TEST_2"></a></p>
  
  <p>So far, this is the statement that I have been doing and it return the same value of D for every row in A.</p>
  
  <p><a href="https://i.stack.imgur.com/h1TFm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h1TFm.png" alt="Query result"></a></p>
  
  <p>Currently I am using toad for oracle, but I tried using the same logic in MySQL and it works fine.</p>