I need a query to get the expected results..
Here is sample data...
Table: Mrelation
Mastercolumn detailscolumn
/test/sample/data /detail/folder1/plac2
/test/sample/data /detail/folder1/plac3
/test/sample/data /detail/folder1/plac4
/test/sample/data /detail/folder1/pla22
Expected output:
Mastercolumn detailcolumn1 detailcolumn2 detailcolumn3 detailcolumn4
/test/sample/data /detail/folder1/plac2 /detail/folder1/plac3 /detail/folder1/plac4 /detail/folder1/pla22
Thanks for your help..