查询结果有问题 [英] Problem in query result

问题描述

SELECT     FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ReceivedDate, ProjectName,
                      ReceivedRemarks, IssueTime, ReceiveTime
FROM         Issue
WHERE     (format(IssueDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy')) OR
                      (format(ReceivedDate, 'dd-mm-yyyy') BETWEEN format(?, 'dd-mm-yyyy') AND format(?, 'dd-mm-yyyy'))
ORDER BY ReceivedDate

它返回677个结果.

It returns 677 results.

<br />
<pre lang="sql">SELECT     FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ProjectName,<br />
                     IssueTime From         Issue<br />
WHERE     (format(IssueDate, &#39;dd-mm-yyyy&#39;) BETWEEN format(?, &#39;dd-mm-yyyy&#39;)</pre><br />
<br />

它返回362个结果.

it returns 362 results.

<br />
<pre lang="sql">SELECT     FileNo, ReqControlNo, Requester, ReqDate, IssueDate, DueDate, RequesterDeptt, Remarks, HandOverTo, RecordType, ReceivedDate, ProjectName,<br />
                      ReceivedRemarks, IssueTime, ReceiveTime<br />
FROM         Issue<br />
WHERE     ( (format(ReceivedDate, &#39;dd-mm-yyyy&#39;) BETWEEN format(?, &#39;dd-mm-yyyy&#39;) AND format(?, &#39;dd-mm-yyyy&#39;))</pre><br />
<br />

它返回338个结果.
为什么Query1结果！= Query2 + query3结果.
非常紧急.
帮帮我吧！
问题是第一个查询不包括当天发出和接收的那些文件.


从OP更新:我得到了解决方案.这是我的概念性错误.

it returns 338 results.
why Query1 result !=Query2+query3 results.
it''s very urgent.
help me!
Problem is that the first query is not include those files that are issued and received same day.


Update from OP: I got the solution.It''s my conceptual mistake.

推荐答案

第二个查询在where子句中使用IssueDate，而其他查询则使用ReceivedDate

second query uses IssueDate in the where clause, while the other queries use ReceivedDate

这篇关于查询结果有问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！