SELECT 
ITEM_CODE AS ITEM,
ITEM_NAME AS I_NAME,
CL_NAME AS C_NAME,
SIZE_NAME AS S_NAME
FROM ITEM 
LEFT OUTER JOIN COLOR_TBL
LEFT OUTER JOIN SIZE_TBL
WHERE STOCK_MANAGEMENT_TYPE = 1;