Select
ITEM.ITEM_CODE AS ITEM,
ITEM.ITEM_NAME AS I_NAME,
COLOR_TBL.CL_NAME AS C_NAME,
SIZE_TBL.SIZE_NAME AS S_NAME
FROM
ITEM
inner JOIN SIZE_TBL
inner JOIN COLOR_TBL

where
STOCK_MANAGEMENT_TYPE = 1
order by
ITEM_CODE ,
CL_CODE,
SIZE_CODE