I have a simple ANYINTERACT query join (see attached).
When I try to view the results on sql developers map viewer, I see this error:
ORA-01445 cannot select ROWID from, or sample, a join view without a key-preserved table
I suspect this has to do with the same geometry appearing multiple times, or perhaps I should add a bogus id fields, or perhaps I need to fashion this query like a CTE (common table expression).
I wanted to see if anyone had an easy solution to this error.
Thank you