更新时间:2023-01-29 16:41:17
尝试:
HAVING rtam.dbo.wfm_process_instance.LOCAL_USER_START_TIME
>= CONVERT(DATE, MIN(rtam.dbo.gnr_tbl_72_type.LOCAL_COL_113))
AND rtam.dbo.wfm_process_instance.LOCAL_USER_START_TIME
< DATEADD(DAY, 1, CONVERT(DATE, MAX(rtam.dbo.gnr_tbl_72_type.LOCAL_COL_113))
您可能还会考虑使用别名,这样就不必在代码中重复使用冗长且容易出错的引用,例如rtam.dbo.wfm_process_instance
.
You might also think about using aliases so that you don't have to repeat lengthy and error-prone references like rtam.dbo.wfm_process_instance
all over your code.