select
  i.item_code as ITEM,
  i.item_name as I_NAME,
  c.cl_name as C_NAME,
  s.size_name as S_NAME
FROM
  item i,
  size_tbl s,
  color_tbl c
where
  stock_management_type = 1
order by
  i.item_code,
  c.cl_code,
  s.size_code