title: MySQL COUNT(*) GROUP BY HAVING COUNT=?
body: <p>This my Query</p>
  
  <pre><code>SELECT COUNT(*) as total, toys, date FROM T1
   WHERE (date &gt;= '2012-06-26'AND date &lt; '2012-06-30') AND (Avail &gt; '0')
  UNION
  SELECT COUNT(*) as total, toys, date FROM T2
   WHERE (date &gt;= '2012-06-26'AND date &lt; '2012-06-30') AND (Avail &gt; '0')
  UNION
  SELECT COUNT(*) as total, toys, date FROM T3
   WHERE (date &gt;= '2012-06-26'AND date &lt; '2012-06-30') AND (Avail &gt; '0')
  GROUP BY RoomType
  HAVING COUNT( total ) = 4
  </code></pre>
  
  <p>Output result</p>
  
  <pre><code>count   Toys            date
  3   Bibi        2012-06-26
  4   Baba            2012-06-26
  </code></pre>
  
  <p>How can i get MYSQL to show results only for count=4</p>