+ 0 Votes Um.... Slayer_ 2 years ago It sounds like you are saying<pre>Select * from Questions Where Question_Points=150</pre> + 0 Votes Reponse To Answer StojanMk 2 years ago The trick is: the sum(Question_Points) = 150. For example, lets say Question_Points of the 1st row is 10, Question_Points of the 2nd row is 20, of the 3rd row is 15, and randomly so on. So, the sum of the selection need to be 150. Greetings + 0 Votes Reponse To Answer Slayer_ 2 years ago So are you trying to select question text that has a sum of 150?I hope these are in two different tables then.Im a it rusty, but I think its something likeSelect Question_Text, sum(Question_Points) From Questions Group by Question_TextThat should give you the total points for each question. I cannot remember how to narrow it down further. + 0 Votes Reponse To Answer StojanMk 2 years ago I'll give you detailed example. Lets say the table is like this:Id Question_Text Question_Points1 Question1 52 Question2 53 Question3 104 Question4 55 Question5 5Can we make elegant selection where sum(Question_Points) = 20, and the result set would be like this:1 Question1 52 Question2 53 Question3 10 [5+5+10=20] , Or the result set would be like this:3 Question3 104 Question4 55 Question5 5[10+5+5=20] The sum is again 20, or the result set would be like this:1 Question1 52 Question2 54 Question4 55 Question5 5 The sum is again 20. I'll emphasize again that the result selection should be randomly chosen. Hope better explained n 10x 4 ur attention.