Showing full list of names of features within polygon when hovering over it in QGIS

Question

In QGIS I've successfully joined three tables of data: 'Addresses', 'Persons', and 'Polygons'. The polygons represent the address on the map, and each address "contains" the names of all people on that address:

I want to use Display/Map tips to show a list of all people on every address when hovering over the polygon corresponding to the address. I've done this by pasting [% "Person_Name” %] in the Display tab of the properties.

However, I cannot figure out how to print a full list of names. Only the first name on the list appears:

Is there a solution to print a full list of names when hovering over the address/polygon?

Answer 1

Can using "Virtual Layer" through Layer > Add Layer > Add/Edit Virtual Layer... to join the tables be an option?

For each address, a list of the names is created. The map tip is then displayed when hovering over the virtual layer.

select  p.adress, 
        p.geometry, 
        group_concat(a.name) as residents from Polygons p
left join adress a
on p.adress = a.adress
group by p.adress

.

.