开发者

Need to query "order date" larger than "filled date" any suggestions?

开发者 https://www.devze.com 2023-01-08 12:51 出处:网络
I have a query with over 500,000 rows of data in the output. I need to filter the criteria down so that I am comparing column \"order date\" to column开发者_运维知识库 \"filled date\". I want to find

I have a query with over 500,000 rows of data in the output. I need to filter the criteria down so that I am comparing column "order date" to column开发者_运维知识库 "filled date". I want to find all orders with a filled date sooner than an order date (yes, that sounds backwards). Is there an easy way to query this in design view? I am not very good with SQL.


You want the SQL to look something like this:

SELECT *
FROM yourtable
WHERE filled_date < order_date

How to do it in the designer depends on which designer you are using.


try

select *
from [orders]
where [filled date] > [order date]

obviously use your field and table names

0

精彩评论

暂无评论...
验证码 换一张
取 消