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 ASC,
CL_CODE ASC,
SIZE_CODE ASC;