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
cross join COLOR_TBL
where STOCK_MANAGEMENT_TYPE = 1
order by item_code, cl_code, size_code;