using DISTINCT

[OwenTheSamoan]

Perhaps someone can tell me where I am going wrong. No matter how much I try to redo this query using "DISTINCT" I still get duplicate results. Can someone please tell me where I am going wrong?

$query = "SELECT DISTINCT table1.username, table2.username, state, height, age, activity from table1, table2 where table1.username = table2.username ORDER by activity desc";

[Kudose]

Try somethin like:

$query = "SELECT DISTINCT t1.username, t2.username, t1.state, ";
 $query .= "t1.height, t1.age, t1.activity FROM ";
 $query .= "table1 AS t1, table2 AS t2 WHERE t1.username = t2.username ";
 $query .= "ORDER BY t1.activity DESC";

[OwenTheSamoan]

works perfectly. Thanks!!

[Kudose]

No problem. Please mark this thread resolved.