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