CADYOMIKOMIテーブルというのは、堀さんから貰ったMTUファイルを一時テーブルに保存しました。
■SQL1(長さ、厚さ、幅、特級、材種で結合):
SELECT B.meisai_no ,A.suuyou 
,D.hinmei ,A.new_bui_cd ,B.new_bui_cd 
  FROM CADYOMIKOMI as A
  inner join m_ss_meisai_cad_data  as B
  on A.cad_size_height =B.cad_size_height 
  and A.cad_size_long =B.cad_size_long 
  and A.cad_size_width =B.cad_size_width 
  and A.cad_toukyuu_cd =B.cad_toukyuu_cd 
  and A.cad_zaisyu_cd =B.cad_zaisyu_cd
  inner join m_ss_meisai D
  on B.meisai_no =D.meisai_no 
■SQL2(長さ、厚さ、幅、特級、材種、新部位コードで結合):
SELECT B.meisai_no ,A.suuyou 
,D.hinmei ,A.new_bui_cd ,B.new_bui_cd 
  FROM CADYOMIKOMI as A
  inner join m_ss_meisai_cad_data  as B
  on A.cad_size_height =B.cad_size_height 
  and A.cad_size_long =B.cad_size_long 
  and A.cad_size_width =B.cad_size_width 
  and A.cad_toukyuu_cd =B.cad_toukyuu_cd 
  and A.cad_zaisyu_cd =B.cad_zaisyu_cd
  and A.new_bui_cd =B.new_bui_cd  
  inner join m_ss_meisai D
  on B.meisai_no =D.meisai_no