SQL Subquery with two selects from different table is giving random selection
<p>SQL Subquery with two selects from different table is giving random selection </p>

<pre><code>select top(1) Questions.Ques_ID, Question 
from Questions 
where   Questions.Ques_ID in(
                   select   top(4)  Answers.Que_ID,Answer 
                   from Answers 
                   where  Questions.Ques_ID = Answers.Que_ID   
                   order by newid())
</code></pre>

<p><a href="https://i.stack.imgur.com/5g5CT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5g5CT.png" alt="enter image description here"></a></p>