I have a query that returns multiple rows. There is one column that I want to concatenate into the same column. I have a query that can return the result below.
ID | FirstName | LastName | City | State | Phone | SystemDate
1 | John | Doe | ABC | FL | 5555555555 | 2020-12-01
1 | John | Doe | ABC | FL | 8888888888 | 2020-12-01
2 | Jane | Smith | XYZ | CA | 9999999999 | 2020-12-01
What I would like to do is have the output look like this instead.
ID | FirstName | LastName | City | State | Phone | SystemDate
1 | John | Doe | ABC | FL | 5555555555, 8888888888 | 2020-12-01
2 | Jane | Smith | XYZ | CA | 9999999999 | 2020-12-01
Here is my query that can do the first output.
select a.idref, p.firstname, p.lastname, d.city, d.state, m.phone, m.createdate
from master m
join demographics d on m.did = d.id
join commoninfo c on d.eid = c.id
join acounts a on c.aid = a.id
join people p on a.pid = p.id
where m.createdate >= trunc(sysdate + interval '-1' day);
Any tips or hints for this newbie is greatly appreciated. Thanks in advance.