select i.ITEM_CODE as ITEM
, i.ITEM_NAME as I_NAME
, ct.CL_NAME as C_NAME
, st.SIZE_NAME as S_NAME
from item as i
cross join size_tbl as st
cross join COLOR_TBL as ct
where STOCK_MANAGEMENT_TYPE = 1
order by ITEM_CODE, CL_CODE, SIZE_CODE;