SVC Tech Inventory Stock Work (SVC00720)

SELECT
       ['SVC Tech Inventory Stock Work'].USERID AS 'SVC Tech Inventory Stock Work-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC00720 AS ['SVC Tech Inventory Stock Work']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SVC Tech Inventory Stock Work'].USERID = ['Users Master'].USERID

SELECT
       ['SVC Tech Inventory Stock Work'].ITEMNMBR AS 'SVC Tech Inventory Stock Work-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC00720 AS ['SVC Tech Inventory Stock Work']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['SVC Tech Inventory Stock Work'].ITEMNMBR = ['Item Master'].ITEMNMBR

SELECT
       ['SVC Tech Inventory Stock Work'].LOCNCODE AS 'SVC Tech Inventory Stock Work-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SVC00720 AS ['SVC Tech Inventory Stock Work']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SVC Tech Inventory Stock Work'].LOCNCODE = ['Site Setup'].LOCNCODE