select A.ITEM_CODE as ITEM , A.ITEM_NAME as I_NAME, C.CL_NAME as C_NAME, B.SIZE_NAME as S_NAME
from ITEM A 
cross join SIZE_TBL B
cross join COLOR_TBL C
order by ITEM_CODE,CL_CODE,SIZE_CODE;