select ITEM_CODE as 'ITEM',
ITEM_NAME as 'I_NAME',
CL_NAME as 'C_NAME',
SIZE_NAME as 'S_NAME'
from ITEM
cross join COLOR_TBL
cross join SIZE_TBL
where STOCK_MANAGEMENT_TYPE = 1
order by ITEM_CODE,
CL_CODE,
SIZE_CODE