title: I want to get the data form form mysql table where data match with right side or not
body: <pre><code>SELECT a.*,b.clientId,c.partner_name, d.seo 
  FROM project_estimate_detail as a,
      project as b,
      partner as c,
      projection as d 
  WHERE a.project_cat_id = 5 and 
        a.project_id = b.id and 
        b.clientId = c.id and 
        c.status =1 and c.id = d.client_id 
  GROUP BY(c.partner_name)
  </code></pre>
  
  <p><code>in c.id = d.client_id</code> .. I want all row form c.id who match with or do not match <code>d.client_id</code> </p>