MMEX Desktop v1.3.4.rc.2 is ready ... 1.3.4-rc.2


Build and share your cool customized reports built w/ one sql, Chart.js and Lua (
Post Reply
MMEX Developer
Posts: 1176
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia


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