title: sql query is not working properly
body: <p>i am trying to get non matching records from two table by comparing some columns which are common in both tables.i am using sql query to get the result. my first table is  snd_marketvisits this table have properties like id ,pjpCode , section code, popCode .pop_name and landmark similary my 2nd table have pjpcode , section code, popcode popname are common and there are some other fields.i want to get the names of the pop which are not in second table but present in snd_marketvisit table by comparing popcode, sectioncode and pjpcode in both tables. </p>
  
  <pre><code>SELECT * 
  FROM snd_marketvisits sm 
  LEFT JOIN snd_marketvisit_pops sp ON 
    sm.distributorCode = sp.distributor AND 
    sm.pjpCode = sp.pjp AND 
    sm.sectionCode = sp.sectionCode AND 
    sm.popCode = sp.popCode 
  WHERE 
    sm.sectionCode = '00016' AND 
    sm.pjpCode = '0001' AND 
    sm.distributorCode = '00190A' 
  </code></pre>