select 
item_code as ITEM,
item_name as I_NAME,
cl_name as C_NAME,
size_name as S_NAME
from item as i
cross join color_tbl
cross join size_tbl
where stock_management_type = 1
order by item_code,cl_code,size_code asc