SELECT mapg_id, tab_to_string ( CAST ( COLLECT ( sourcetypes.stname || ': ' || sources.sIdentifier) AS t_varchar2_tab), '', '; ') AS sources FROM sources, mapgroup_source, sourcetypes WHERE mapgroup_source.source_id = sources.source_id AND sourcetypes.sourcet_id = sources.sourcet_id GROUP BY mapg_id;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)