select
item_code as ITEM
,item_name as I_NAME
,cl_name as C_NAME
,size_name as S_NAME

from item
cross join size_tbl
on 1=1
cross join color_tbl
on 1=1
where STOCK_MANAGEMENT_TYPE = 1
order by item_code,cl_code,size_code