--select * FROM ITEM;
--select * FROM COLOR_TBL;
--select * FROM SIZE_TBL;
select 
I.ITEM_CODE as ITEM, 
I.ITEM_NAME as I_NAME, 
C.CL_NAME as C_NAME, 
S.SIZE_NAME as S_NAME
FROM ITEM I, COLOR_TBL C, SIZE_TBL S
WHERE I.STOCK_MANAGEMENT_TYPE=1
ORDER BY ITEM_CODE asc,
CL_CODE asc,
SIZE_CODE asc
;