SQL Uniqu Values
I have this query that joins 3 table. It appears to be working but I am getting duplicates. How can i remove the duplicates?

    SELECT FIRST 100 e.email_id, e.location_id, e.email, l.location_type, p.salutation, p.fname, p.lname
    FROM email e, location l, person p
    WHERE e.location_id = l.location_id
    AND l.per_id = p.per_id
SQL Uniqu Values
===

I have this query that joins 3 table. It appears to be working but I am getting duplicates. How can i remove the duplicates?

    SELECT FIRST 100 e.email_id, e.location_id, e.email, l.location_type, p.salutation, p.fname, p.lname
    FROM email e, location l, person p
    WHERE e.location_id = l.location_id
    AND l.per_id = p.per_id