List Equipment Import Work Table (SVC00325)

SELECT
       ['List Equipment Import Work Table'].USERID AS 'List Equipment Import Work Table-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVC00325 AS ['List Equipment Import Work Table']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['List Equipment Import Work Table'].USERID = ['Users Master'].USERID

SELECT
       ['List Equipment Import Work Table'].ITEMNMBR AS 'List Equipment Import Work Table-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SVC00325 AS ['List Equipment Import Work Table']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['List Equipment Import Work Table'].ITEMNMBR = ['Item Master'].ITEMNMBR

SELECT
       ['List Equipment Import Work Table'].CUSTNMBR AS 'List Equipment Import Work Table-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC00325 AS ['List Equipment Import Work Table']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['List Equipment Import Work Table'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR