Company Code에 종속된 Plant

SELECT a~werks, a~name1
  FROM T001W AS a 
  LEFT JOIN T001K as b on b~bwkey = a~bwkey
                      and b~bukrs = @Company 입력값
                      and a~werks = @Plant 입력값.