select ITEM_CODE as ITEM,ITEM_NAME as I_NAME,CL_NAME as C_NAME,SIZE_NAME as S_NAME
from item
cross join color_tbl
cross join size_tbl
where STOCK_MANAGEMENT_TYPE	=1
order by ITEM_CODE asc,CL_CODE asc,SIZE_CODE asc;