How to bring to a single price + sorting with a condition?

Question

MySQL

We have two tables, one with entities (price and currency code). The second is the currency code and rate.
How to make a selection from entities with conditions by price (<=, >= and sort from lower to higher and vice versa, having entities with different prices in different currencies?
Thanks in advance for your help.

Answer 1

SELECT e.id,e.name, (e.price*c.quotation) as factPrice from entitys as e
INNER JOIN currencys as c ON c.id = e.curr_id
ORDER BY factPrice

Well, you can try this. It won't work fast.