SELECT ITEM_CODE AS ITEM, ITEM_NAME AS I_NAME, CL_NAME AS C_NAME, SIZE_NAME AS S_NAME FROM SIZE_TBL CROSS JOIN (SELECT * FROM COLOR_TBL CROSS JOIN (SELECT * FROM ITEM WHERE STOCK_MANAGEMENT_TYPE=1));