특성 값 리스트 조회 쿼리

SELECT
       h.klart
     , h.class
     , c.atnam
     , t.atbez
     , w.atwrt
     , wt.atwtb

  FROM  klah h
      , ksml s
      , cabn c
      , cabnt t
      , cawn w
      , cawnt wt
  WHERE h.mandt = '200'
    AND h.klart = '023'
    AND h.class = 'SSC_HALB_01'

    AND s.mandt = h.mandt
    AND s.clint = h.clint

    AND c.mandt = s.mandt
    AND c.atinn = s.imerk

    AND t.mandt = c.mandt
    AND t.atinn = c.atinn
    AND t.spras = '3'

    AND w.mandt = c.mandt
    AND w.atinn = c.atinn
    AND w.adzhl = c.adzhl

    AND wt.mandt = w.mandt
    AND wt.atinn = w.atinn
    AND wt.atzhl = w.atzhl
    AND wt.spras = '3'