Select a record by name, and also all records having that record's address?
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";