Extended Pricing Quantity Breaks (SOP40703)

SELECT
       ['Extended Pricing Quantity Breaks'].USERID AS 'Extended Pricing Quantity Breaks-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SOP40703 AS ['Extended Pricing Quantity Breaks']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Extended Pricing Quantity Breaks'].USERID = ['Users Master'].USERID

SELECT
       ['Extended Pricing Quantity Breaks'].CUSTNMBR AS 'Extended Pricing Quantity Breaks-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SOP40703 AS ['Extended Pricing Quantity Breaks']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Extended Pricing Quantity Breaks'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

SELECT
       ['Extended Pricing Quantity Breaks'].ITEMNMBR AS 'Extended Pricing Quantity Breaks-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       SOP40703 AS ['Extended Pricing Quantity Breaks']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['Extended Pricing Quantity Breaks'].ITEMNMBR = ['Item Master'].ITEMNMBR