擅长:python、mysql、java
<p><code>Date</code>和<code>Time</code>是<a href="https://support.office.com/en-us/article/Access-2007-reserved-words-and-symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe?CorrelationId=f6e90344-348c-4565-a54d-9144f0720e7e&ui=en-US&rs=en-US&ad=US" rel="nofollow">reserved words in Access</a>,请确保在查询中使用的任何位置对保留字进行转义:</p>
<pre><code>SELECT [Date], [Time], [uSec], [twoCV]
FROM [table_a] WHERE ([Date] = ? AND [Time] > ?)
OR ([Date] > ?)
</code></pre>