title: How can i get remaining rows after inner join in mysql
body: <p>I have two tables</p>
  
  <p>1.Applicants table(id , name)</p>
  
  <p>2.posts table(id , post_name ,applicant_id)</p>
  
  <p>If i do inner join, I will get applicants who are having posts ( SELECT COUNT(*) FROM <code>applicants</code> INNER JOIN <code>posts</code> ON <code>posts</code>.<code>applicant_id</code> = <code>applicants</code>.<code>id</code> ).</p>
  
  <p>Now what i need to do for getting applicants who are not having any posts.</p>