NC_MCI_Bank_Details_TEMP (NCABR409)

SELECT
       ['NC_MCI_Bank_Details_TEMP'].USERID AS 'NC_MCI_Bank_Details_TEMP-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       NCABR409 AS ['NC_MCI_Bank_Details_TEMP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['NC_MCI_Bank_Details_TEMP'].USERID = ['Users Master'].USERID

SELECT
       ['NC_MCI_Bank_Details_TEMP'].INTERID AS 'NC_MCI_Bank_Details_TEMP-Intercompany ID'
       ,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
       NCABR409 AS ['NC_MCI_Bank_Details_TEMP']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['NC_MCI_Bank_Details_TEMP'].INTERID = ['Company Master'].INTERID

SELECT
       ['NC_MCI_Bank_Details_TEMP'].CURNCYID AS 'NC_MCI_Bank_Details_TEMP-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       NCABR409 AS ['NC_MCI_Bank_Details_TEMP']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['NC_MCI_Bank_Details_TEMP'].CURNCYID = ['Currency Setup'].CURNCYID