title: mysql doesn't show result if the query option has empty record in one of the table
body: <p>I have two tables that store data for my wife application.</p>
  
  <p>I don't have a problem to load the profile from customer table if there is a record from services table.</p>
  
  <p>But mysql code doesn't work if query customer record that don't have a record in services table.</p>
  
  <p>here is mysql code: </p>
  
  <pre><code>SELECT *
  FROM customer, services
  WHERE customer.cust_id = services.customer_id
  AND customer.slug  LIKE 'john-doe'
  AND services.deleted = '0'
  </code></pre>
  
  <p>it work perfect for <code>john-doe</code> as it show all record for both customer and services table but
  if i change <strong>john-doe</strong> to <strong>jeff-chew</strong> it show record count 0.</p>
  
  <p>What I trying to achieve is using the same query code for my profile view page.</p>
  
  <p>If there is a services record for this customer, it show display all the record from services table, else if there is no services record found in the services table, it should show only profile data from customer table.</p>
  
  <p>here is <a href="http://sqlfiddle.com/#!2/83871b/1" rel="nofollow">sqlfiddle</a></p>