select ITEM_CODE as ITEM,ITEM_NAME as I_NAME,CL_NAME as C_NAME,SIZE_NAME as S_NAME
from item,color_tbl,size_tbl
where STOCK_MANAGEMENT_TYPE	=1
order by item asc,C_NAME asc,S_NAME asc