SELECT T1.ITEM_CODE AS ITEM,
       T1.ITEM_NAME AS I_NAM,
       T2.CL_NAME AS C_NAME,
       T3.SIZE_NAME AS S_NAME
  FROM ITEM T1 INNER JOIN COLOR_TBL T2
               INNER JOIN SIZE_TBL T3
 WHERE T1.STOCK_MANAGEMENT_TYPE = '1'
 ORDER BY T1.ITEM_CODE ASC,
          T2.CL_CODE ASC,
          T3.SIZE_CODE ASC