<div>
This will get you the ones that have values... it doesn't return the ones that are null. 
 

<pre><code class="code-1 nolinks" id="code-20-40499414-1">SELECT Table2.status, Count(Table2.status) AS CountOfstatus
FROM Table1 INNER JOIN Table2 ON Table1.id = Table2.id
WHERE (((Table1.when)&gt;=#12/12/2014#))
GROUP BY Table2.status;
</code></pre>
</div>

<div>
Is there a &quot;.when&quot; clause in MySQL also, what is this # symbol? I tried the following statement but it did not work: 
 
SELECT table2.status, Count(table2.status) AS CountOfstatus 
FROM table1 INNER JOIN table2 ON table1.id = table2.id 
WHERE ((table1.when)&gt;=#12/12/2014#) 
GROUP BY table2.status 
 
The error is : 
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY table2.status LIMIT 0, 30' at line 4
</div>

<div>
Also, if you need a query that returns null for those values in status that have no records within the date range you specify, it gets a little more complicated. &nbsp; 
 
Do you have the values for status stored in a separate table? &nbsp;(one with four rows containing 'Approved' 'Started' 'In Progress' 'Complete') &nbsp; If you do, you could use a left join from that table to a sub-query containing the query I posted above. &nbsp; For example, if the lookup table is called 'status_tbl': 
 

<pre><code class="code-1 nolinks" id="code-20-40499550-1">Select a.status, b.CountOfstatus from status_tbl as a LEFT JOIN 
 (
 SELECT Table2.status, Count(Table2.status) AS CountOfstatus
 FROM Table1 INNER JOIN Table2 ON Table1.id = Table2.id
 WHERE (((Table1.when)&gt;=#12/12/2014#))
 GROUP BY Table2.status;
 ) AS b ON a.status = b.status;
</code></pre>
</div>

<div>
Sherman, looks like for the second query you have not done it with MySQL :-). Thank you very much for your help. I am taking a look at this. 
 
A
</div>

<div>
Sherman, thank you. I was able to figure it out with the guidance you gave me. &nbsp;Thanks again for the help. 
 
A
</div>

<div>
<div class="content wysiwyg-content">
I have two tables as follows: 
Table-01 
id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date 
1001 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11/1/2014 
1002 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12/1/2014 
1003 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11/12/2014 
1004 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11/28/2014 
1005 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11/14/2014 
1006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11/29/2014 
1007 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11/14/2014 
1008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12/10/2014 
1009 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12/12/2014 
1010 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12/12/2014 
1011 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12/8/2014 
 
Table-02 
id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; status 
1001 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Started 
1002 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Started 
1003 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Started 
1004 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;In Progress 
1005 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Complete 
1006 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Complete 
1007 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Complete 
1007 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Approved 
1008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Approved 
1009 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Approved 
1010 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Complete 
1011 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Complete 
 
I need to get an output that will be give me the count status depending on the date from table-01. 
 
For eg, If I need the count of status for date &gt;= 12/12/2014, I am looking for an output as follows: 
 
Approve &nbsp;1 
Completed 1 
Started &nbsp;null 
in Progress null 
 
Can someone let me know how this can be done, thank you. 
 
A
</div>
</div>

I have two tables as follows:
Table-01
id	         Date
1001	11/1/2014
1002	12/1/2014
1003	11/12/2014
1004	11/28/2014
1005	11/14/2014
1006	11/29/2014
1007	11/14/2014
1008	12/10/2014
1009	12/12/2014
1010	12/12/2014
1011	12/8/2014

Table-02
id             status
1001	Started
1002	Started
1003	Started
1004	In Progress
1005	Complete
1006	Complete
1007	Complete
1007	Approved
1008	Approved
1009	Approved
1010	Complete
1011	Complete

I need to get an output that will be give me the count status depending on the date from table-01.

For eg, If I need the count of status for date >= 12/12/2014, I am looking for an output as follows:

Approve  1
Completed 1
Started  null
in Progress null

Can someone let me know how this can be done, thank you.

A

count with join statement...

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.