Get Last month and Current month Data from Two table based on Response Text
<p>I want to get <code>QuestionText</code> for all the question those were marked <code>yes</code> In last month but no in current month.</p>

<p>I have two table <strong>QuestionMaster</strong></p>

<pre><code>QuestionID | QuestionText
</code></pre>

<p>Other Table is <strong>ResponsesMaster</strong></p>

<pre><code>ResponseID | ResponseText | QuestionID | ResponseDateTime
</code></pre>

<p>Response Date Time is in <code>VARCHAR</code>.</p>

<p>Following Query Returns All the responses. I want as mentioned above. </p>

<pre><code>SELECT QM.QuestionText, AR.AssessmentID, AR.ResponseText 
FROM QuestionMaster QM, ResponsesMaster AR 
WHERE AR.QuestionID = QM.QuestionID  
</code></pre>