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;