select item.item_code as ITEM, item.item_name as I_NAME, color_tbl.CL_NAME as  C_NAME, size_tbl.size_name as S_NAME from item, color_tbl, size_tbl where STOCK_MANAGEMENT_TYPE = 1
order by item.item_code, color_tbl.cl_code, size_tbl.size_code
;