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

2161
1
03-01-2016 11:43 AM
PeterLi1
New Contributor III

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 !!!

0 Kudos
1 Reply
PeterLi1
New Contributor III

The above queries are for ArcSDE and SQL Server 2008 R2

0 Kudos