SELECT
ITEM.ITEM_CODE AS ITEM,
ITEM.ITEM_NAME AS I_NAME,
COLOR_TBL.CL_NAME AS C_NAME,
SIZE_TBL.SIZE_NAME AS S_NAME
FROM ITEM
JOIN COLOR_TBL ON ITEM.ITEM_CODE = COLOR_TBL.CL_CODE
JOIN SIZE_TBL ON ITEM.ITEM_CODE = SIZE_TBL.SIZE_CODE
WHERE ITEM.STOCK_MANAGEMENT_TYPE = 1
ORDER BY ITEM.ITEM_CODE ASC, COLOR_TBL.CL_CODE ASC, SIZE_TBL.SIZE_CODE ASC;