Currencies
Posted: Thu Jan 30, 2014 6:51 pm
Code: Select all
select c.currency_symbol, c.currencyname, c.baseconvrate, c2.currency_symbol as base_symbol
from currencyformats_v1 c
left join infotable_v1 i on i.infoname='BASECURRENCYID'
left join currencyformats_v1 c2 on c2.currencyid = i.infovalue