mysql> select UserPrimes.CandidateName from UserPrimes join Candidate on UserPrimes.CandidateName = Candidate.CandidateName where k=21 order by n; +----------------+ | CandidateName | +----------------+ | 21*2^1170083-1 | | 21*2^1182083-1 | | 21*2^1452771-1 | | 21*2^1872923-1 | | 21*2^2160479-1 | | 21*2^2959789-1 | +----------------+ 6 rows in set (0.00 sec)