AnsweredAssumed Answered

Why definition query on date field is treated differently for two tables joining and three table joining?

Question asked by pliottawa888 on Mar 1, 2016
Latest reply on Mar 1, 2016 by pliottawa888

For ArcGIS 10.3.1 and SQL Server 2008 R2 environment, in the Definition Query of ArcMap:

When using two joining tables, the query can be simple:

table1.starting > '2016-02-29 00:00:00'

 

However, using three joining tables, the query has to be the following for ArcGIS 10.3.1, but it doesn't work for ArcGIS 10.1:

 

table2.id2 > 0 AND table3.id3 > 0 AND table1.starting > date'2016-02-29 00:00:00'

 

Why should they be different using date or not? Many simple queries by using Date work for two joining tables, but DO NOT WORK for three joining tables !!!

Outcomes