mysql> select a.ADDRESS_1, a.CITY, a.ZIP , ea.email_address, u.ssn from email_address ea inner join address a on ea.user_id = a.user_id inner join users u on u.user_id = ea.user_id where ea.email_address like '%@mantech%'\G
*************************** 1. row ***************************
    ADDRESS_1: 1370-A Remount Road
         CITY: N. Charleston
          ZIP: 29406
email_address: KIRK.SPLETZER@MANTECH.COM
          ssn: 123463069
*************************** 2. row ***************************
    ADDRESS_1: 161 Dogwood Court
         CITY: Daniels
          ZIP: 25832
email_address: GENE.CIRAK@MANTECH.COM
          ssn: 123498778
*************************** 3. row ***************************
    ADDRESS_1: 322 Summers St
         CITY: Hinton
          ZIP: 25951
email_address: KEVIN.THROCKMORTON@MANTECH.COM
          ssn: 123498793
*************************** 4. row ***************************
    ADDRESS_1: 14225 Heritage Crossing Lane
         CITY: Centreville
          ZIP: 20120
email_address: MILLIAM.ALVAREZ@MANTECH.COM
          ssn: 123525457
*************************** 5. row ***************************
    ADDRESS_1: 15606 humberside way
         CITY: upper marlboro
          ZIP: 20774
email_address: JAMESH.POOLE@MANTECH.COM
          ssn: 123501291
*************************** 6. row ***************************
    ADDRESS_1: 15606 humberside way
         CITY: upper marlboro
          ZIP: 20774
email_address: JAMES.POOLE@MANTECH.COM
          ssn: 123501291
*************************** 7. row ***************************
    ADDRESS_1: 15788 Barcelona Court
         CITY: Woodbridge
          ZIP: 22191
email_address: SHANCE.DOCTOR@MANTECH.COM
          ssn: 123501301
*************************** 8. row ***************************
    ADDRESS_1: 6811 Meteor Place
         CITY: Springfield
          ZIP: VA
email_address: BRIAN.SOHL@MANTECH.COM
          ssn: 123510596
*************************** 9. row ***************************
    ADDRESS_1: 6811 Meteor Place
         CITY: Springfield
          ZIP: VA
email_address: BRIAN.SOHL@MANTECH.COM
          ssn: 123510596
*************************** 10. row ***************************
    ADDRESS_1: 4303 Auburn Dr.
         CITY: Killeen
          ZIP: 76549
email_address: LEE.NIXON@MANTECH.COM
          ssn: 123514050
*************************** 11. row ***************************
    ADDRESS_1: 1028 Croton Drive
         CITY: Alexandria
          ZIP: 22308
email_address: MICHAEL.POWERS@MANTECH.COM
          ssn: 123517024
*************************** 12. row ***************************
    ADDRESS_1: 192 Goldsborough dr
         CITY: Odenton
          ZIP: 21113
email_address: JOSEPH.KACVINSKY@MANTECH.COM
          ssn: 123521146
*************************** 13. row ***************************
    ADDRESS_1: 4812 Reilly Drive
         CITY: Clinton MD
          ZIP: 20735
email_address: THOMAS.MORRIS@MANTECH.COM
          ssn: 123521212
*************************** 14. row ***************************
    ADDRESS_1: 43 Black Pine Lane
         CITY: Lumberton
          ZIP: 08048
email_address: WALTER.MAYS@MANTECH.COM
          ssn: 123523254