Using DISTINCT with join

[jeff5656]

I have this query:

 

$query = "select tasks.*, users.email,  users.lname from tasks inner join users on users.id = tasks.user_id where due_date<='$curr_date'";

 

How do I retrieve records so that if there are multiple records with the same email, just select 1 of those records.  I want to generate a list containing all unique emails, not the same email listed more than once.

 

 

[jeff5656]

I figured it out - no need for distinct, I used group by.