问题描述
我正在努力创建一些报告，以查找和计算与货运相关的轮次和成本。数据是从跟踪系统收集的，我无法控制表的结构。
我试图对一些我不再拥有的大学写的查询进行基准测试访问类似的应用程序，但我遇到一些语法错误，不知道为什么。
这是我的查询到目前为止：
SELECT x_logs.alias，x_logs.time，x_logs.date，x_logs.status，x_logs.address，[x_logs.time] - （选择Max（[x_logs.time]）FROM x_logs AS DUP WHERE
x_logs.alias = DUP.x_logs.alias AND x_logs.date = DUP.x_logs.date AND x_logs.status = DUP.x_logs.status
WHERE（（x_logs.date）介于06之间 / 15/07" And" 06/30/07"））;
我想我会有问题以帮助我但是我不确定是什么提前在此列出。请问任何问题，我很乐意回答。我甚至可以发布我正在使用的一些表，如果这会有所帮助，虽然我不知道该怎么做。
提前谢谢！
I am working to create some reports that find and calculate round times and costs related to trucking. The data is gathered from a tracking system and I cannot control the structure of the table.
I am attempting to benchmark off of some queries that were written by a college that I no longer have access to for a similar application but I am running in to some syntax errors and do not know why.
Here is my query so far:
SELECT x_logs.alias, x_logs.time, x_logs.date, x_logs.status, x_logs.address, [x_logs.time]-(Select Max([x_logs.time])FROM x_logs AS DUP WHERE
x_logs.alias = DUP.x_logs.alias AND x_logs.date = DUP.x_logs.date AND x_logs.status = DUP.x_logs.status
WHERE ((x_logs.date) Between "06/15/07" And "06/30/07"));
I imagine there will be questions in order to help me however I am not sure what to list here in advance. Please ask any questions and I will happily answer. I can even post some of the table I''m working with if that will help, although I am not sure how to do so.
Thanks in advance!
推荐答案
这篇关于选择查询中的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！