SELECT
ITEM_CODE ITEM,
ITEM_NAME I_NAME,
CL_NAME C_NAME,
SIZE_NAME 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;