Таблици:

currency (currency_id, name)
currency_rate (date, currency_id, fixing)
estate (estate_id, blaaaaaah,.........., price, currency_id)


Заявка:

select

   e.whatever

from 

  estate e,

  currency_rate cr

where

  (cr.currency_id = e.currency_id) and  

  (cr.date = today) and

  ( (e.price * cr.fixing) between min_shit and max_shit)

Съдържаниет е скрито
Влезте за да го видите