select ITEM_CODE as ITEM, ITEM_NAME as I_NAME, CL_NAME as C_NAME, SIZE_NAME as S_NAME
from ITEM as i, SIZE_TBL as s
cross join COLOR_TBL as c
where i.STOCK_MANAGEMENT_TYPE = 1
order by ITEM asc, CL_CODE asc, SIZE_CODE asc;