Select ITEM_CODE as ITEM,ITEM_NAME as I_NAME ,SIZE_NAME as S_NAME ,CL_NAME as C_NAME
from ITEM 
cross join COLOR_TBL,SIZE_TBL
Where STOCK_MANAGEMENT_TYPE = 1
order by ITEM_CODE , CL_CODE,SIZE_CODE;