Oracle QueryQuery to Join two tables, If there are multiple values in single cell that we need put "on" condition.select rtrim(xmlagg (xmlelement (e, RelationshipName|| ',')).extract ('//text()'), ',') from Relationship WHERE ID IN ( SELECT distinct val FROM Person reln1 ,XMLTABLE('/ol/li/text()'PASSING xmltype(' <ol> <li> ' || REPLACE (reln1.RelationshipId, ',', ' </li> <li> ') || ' </li> </ol> ') COLUMNS val varchar2(10) PATH '/'))