SVC_Meter_Batch_Line (SVC10301)

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

SELECT
       ['SVC_Meter_Batch_Line'].CUSTNMBR AS 'SVC_Meter_Batch_Line-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVC10301 AS ['SVC_Meter_Batch_Line']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SVC_Meter_Batch_Line'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR