如何在显示mysql记录时停止冗余

Question

I am facing problem with redundant record from mysql how to avoid this in this particular query?

$sql = "SELECT  DISTINCT d.*,m.* 
        FROM df_job_meta m 
        LEFT OUTER JOIN df_job_post d ON d.ID = m.JOB_ID 
        WHERE (d.STATUS =:ACTIVE) 
        and ( m.VALUE LIKE :wha ) 
        and d.STATE LIKE :whe 
        order by d.ID DESC";

Answer 1

Just add ... GROUP BY d.ID to get rid of the duplicate IDs