Query looking for duplicates in different tables (2011-2016) and return flag for each year

I have a group of tables of first,middle,last,street,city,state,zip,zip4phone – one for each year 2011-2016.
I wish to make a query (php/mysql) that will return as follows, […]

See original post by invalid@example.com (pmf123)