Hi !
I try to automatize quality tests on data (mostly on attributes), the idea is to play python scripts every 2 weeks on 4 datasets in order the 4 data managers can see the warnings on differnt layers/tables and can improve regularly the quality of their data.
What is amazing, is that I did some SQL queries (in "select by attributes") that work on SDE layers but not on my geodatabase layers !!!
my problem is with UNION
I did a query like this one :
WHERE attribute IN (SELECT aa.... UNION SELECT bb.....)
on SDE layers this query works fine
On GDB layers I can do :
WHERE attribute IN (SELECT aa.... )
WHERE attribute IN (SELECT bb.....)
but
WHERE attribute IN (SELECT aa.... UNION SELECT bb.....)
doesn't work ... I cannot understand why !
Do you have some explanations ?
