Random function on joins

Question

Can any one give me clarity can we apply random function on joins...if yes means then how to??

Answer 1

Hello Priya,

 

  Please go through this link

http://stackoverflow.com/questions/16998873/random-join-in-sql-server