mrpDaysEPS (MRP2130)

SELECT
       ['mrpDaysEPS'].ITEMNMBR AS 'mrpDaysEPS-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       MRP2130 AS ['mrpDaysEPS']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['mrpDaysEPS'].ITEMNMBR = ['Item Master'].ITEMNMBR

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