Select a record by name, and also all records having that record's address?
09:09 27 May 2017

What SQL query would find a record by name, and also all records having that record's address?

I have a voter registration database, and when I look up an individual, I would also like to see who else is registered at their address.

To find someone by name:

SELECT * FROM voters.extract
WHERE first_name = "John" AND last_name = "Doe";

To find someone by address:

SELECT * FROM voters.extract
WHERE street_num = "100" AND addr_unit = "A"
AND street_name = "Main Street" AND town = "My Town";
mysql