SQL/INNER JOIN

SELECT

      PM.COMPANY_CD as companyCd,

      CM.COMPANY_NM as companyNm,

      PM.FACTORY_CD as factoryCd,

      FM.FACTORY_NM as factoryNm,

       NVL(TO_CHAR(PM.DAY_CHECK_COUNT),' ') as dayCheckCount

FROM COMPANY_MST CM, FACTORY_MST FM, LINE_MST LM, PROCESS_MST PM

WHERE 1=1

AND PM.GROUP_CD      = CM.GROUP_CD

AND PM.COMPANY_CD = CM.COMPANY_CD

AND PM.GROUP_CD      = FM.GROUP_CD

AND PM.COMPANY_CD  = FM.COMPANY_CD

AND PM.BRAND_CD      = FM.BRAND_CD

AND PM.FACTORY_CD  = FM.FACTORY_CD

AND PM.GROUP_CD        = LM.GROUP_CD

AND PM.COMPANY_CD   = LM.COMPANY_CD

AND PM.BRAND_CD       = LM.BRAND_CD

AND PM.FACTORY_CD   = LM.FACTORY_CD

AND PM.LINE_CD          = LM.LINE_CD