How to implement the simplest ranking system?

Question

Sphinx

Let's say we have two tables. In one we store textual information. In the other - a certain score. The tables are related as one to one. With a search query by Sphinx, we go through the first one, pull out the necessary information. How to sort the results based on table #2, despite the fact that in the end you need to get some kind of compromise between the accuracy of matching with the query and the score in table 2?