Multicurrency Account Summary History (MC30001)

SELECT
       ['Multicurrency Account Summary History'].CURNCYID AS 'Multicurrency Account Summary History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       MC30001 AS ['Multicurrency Account Summary History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Multicurrency Account Summary History'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['Multicurrency Account Summary History'].CURRNIDX AS 'Multicurrency Account Summary History-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       MC30001 AS ['Multicurrency Account Summary History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Multicurrency Account Summary History'].CURRNIDX = ['Currency Setup'].CURRNIDX

SELECT
       ['Multicurrency Account Summary History'].ACTINDX AS 'Multicurrency Account Summary History-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       MC30001 AS ['Multicurrency Account Summary History']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Multicurrency Account Summary History'].ACTINDX = ['Account Index Master'].ACTINDX