SELECT TABBOPR.KOPR,TABBOPR.KOSU,TABBOPR.KOBO,MAEPR.NOKOPR,MAEPR.UD01PR,MAEPR.UD02PR,MAEPREM.PM,MAEPREM.TIMOUL,MAEPREM.PPUL01,MAEPREM.PPUL02,MAEPREM.TAUL,MAEPREM.VALI,MAEPREM.PMIN,MAEPR.FMPR,MAEPR.PFPR,MAEPR.HFPR,MAEPR.MRPR,MAEPR.RUPR, ISNULL(MAEST.STFI1,0.0) AS STFI , TABBOPR.STMIPR*0 AS VALSTOCK , TABBOPR.STMIPR*0 AS PRMEDIO , 'UNIDAD'=MAEPR.UD01PR,0.0,0.0  FROM TABBOPR WITH ( NOLOCK )  INNER  JOIN MAEPREM ON TABBOPR.EMPRESA=MAEPREM.EMPRESA  INNER JOIN MAEPR ON MAEPR.KOPR=MAEPREM.KOPR AND TABBOPR.KOPR=MAEPR.KOPR  AND MAEPR.TIPR <> 'SSN'  AND MAEPR.TIPR <> 'FLN'  INNER  JOIN MAEST ON TABBOPR.EMPRESA='01' AND TABBOPR.KOSU=MAEST.KOSU AND TABBOPR.KOBO=MAEST.KOBO AND TABBOPR.KOPR=MAEST.KOPR 