title: no code error in my mysql query yet no results
body: <pre class="lang-sql prettyprint-override"><code>
  CREATE TABLE wreport13 
  AS 
  SELECT customers.CName, customers.CIDCard, customers.Cphone, customers.infection, users.UName, authlist.AuthType, checkup.comment 
  FROM ((((checkup 
  INNER JOIN customers ON customers.CID=checkup.CID) 
  INNER JOIN users ON users.UID=checkup.EID) 
  INNER JOIN uauth ON users.UID=uauth.UID)
  INNER JOIN authlist ON authlist.AID=uauth.AuthID) 
  WHERE (checkup.Result=1) 
    and (checkup.QID=9) 
    and (checkup.cdate='2020-05-23') 
    and (uauth.astatus=1)
  </code></pre>
  
  <p>this query should result 4 records but nothing comes out.</p>
  
  <p>please help me to find the error, </p>
  
  <p>when i used this  below query</p>
  
  <pre class="lang-sql prettyprint-override"><code>
      SELECT cdate,COUNT(CID) AS customers
        FROM (checkup
        INNER JOIN questionaire ON questionaire.QID=checkup.QID)
      WHERE checkup.Result=1 and checkup.QID=9 
      GROUP BY cdate
  </code></pre>
  
  <p>and result is </p>
  
  <pre>
  cdate         customers
  2020-05-23     4
  2020-05-25     1
  2020-05-30     3
  2020-05-31     2
  </pre>
  
  <p>the first query is meant to extract the details of the first row of the above query</p>