Selecting/Matching cells that hold the same values as opposed to ID in MySQL/phpMyAdmin Can someone point me in the right direction?

Given tables:

actor_uri_address

----------------------
| ID | URI | Address |
----------------------
|    |     |         |
----------------------


actor_full_name_opc

-------------------------------------------------
| ID | Given Name | Surname | Outward Postcode  |
-------------------------------------------------
|    |            |         |                   |
-------------------------------------------------


I am trying produce a table that contains actor URI, first names, surnames and addresses of actors living at the same addresses on the list (I do not need to supply the address at query time, rather the duplicate values in the address column) on phpMyAdmin.

Below is my query construct so far. Despite all efforts, I have only been able to get it to run and return the entire URIs, first names, surnames and addresses. I am totally stuck on how to have it narrow down to only the actors living at the same address.

SELECT   `actor_uri_address`.`URI`, `actor_full_name_opc`.`Given Name`,
         `actor_full_name_opc`.`Surname`, `actor_uri_address`.`Address`
FROM     `actor_uri_address`
    LEFT JOIN `actor_full_name_opc` ON `actor_full_name_opc`.`ID` = `actor_uri_address`.`ID`
GROUP BY `actor_uri_address`.`URI`, `actor_full_name_opc`.`Given Name`,
         `actor_full_name_opc`.`Surname`, `actor_uri_address`.`Address`
SELECT  GROUP_CONCAT(CONCAT(Given_name, ' ', Surname)),
        Address
    FROM actor_uri_address
    JOIN actor_full_name_opc USING(ID)
    GROUP BY Address
    HAVING COUNT(*) &gt; 1