MMEX Desktop v1.3.4.rc.2 is ready https://sourceforge.net/projects/moneym ... 1.3.4-rc.2

Currencies

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)
Post Reply
Nikolay
MMEX Developer
Posts: 1176
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