Hi,
I have a table which holds the prices of a certain good in all currencies we support. As there are over 200 countries, we only have the pricing of this good for a limited number of currencies. Is there an elegant way to query the DB such that if it does not find the pricing for a certain country it returns the default pricing?

In other words if my customer is from Vietnam and we do not support the local currency, then the retured result should be the pricing in US dollars, for example.


Thanks,
Adrien