#!/bin/sh
join -t: file1 file2
join -t: -1 1 -2 2 file1 file3
join -t: -1 1 -2 2 -o '1.1 1.3 2.1 2.3' address stats