pref_pop_user (POPF0113)

SELECT
       ['pref_pop_user'].CMPANYID AS 'pref_pop_user-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       POPF0113 AS ['pref_pop_user']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['pref_pop_user'].CMPANYID = ['Company Master'].CMPANYID

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

SELECT
       ['pref_pop_user'].LOCNCODE AS 'pref_pop_user-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       POPF0113 AS ['pref_pop_user']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['pref_pop_user'].LOCNCODE = ['Site Setup'].LOCNCODE