我马上想到的是使用SQL连接来实现这一点，即使用SELF JOIN来比较表与其自身，同时还使用子查询来确保地址信息在您正在比较的表上可用。请尝试以下查询，应该会有帮助：

SELECT t2.c2_id as id, t2.c2_name as name
FROM (
SELECT c.id as c1_id, c.name as c1_name, CONCAT(addresses.a1, ' ', addresses.a2, ' ', addresses.city, ' ', addresses.state) as c1_address
FROM companies c
JOIN addresses 
ON c.id = addresses.company_id
) t1, 
(
SELECT c.id as c2_id, c.name as c2_name, CONCAT(addresses.a1, ' ', addresses.a2, ' ', addresses.city, ' ', addresses.state) as c2_address
FROM companies c
JOIN addresses 
ON c.id = addresses.company_id
) as t2
WHERE c1_id <> c2_id
AND c1_address = c2_address;

https://sqlize.online/s/dp