Currencies

Build and share your cool customized reports built w/ one sql, Chart.js and Lua

Moderator: Renato

Post Reply
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Currencies

Post by Nikolay »

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
Post Reply