I want to get a list of all the polygons from table 2 which overlap with one polygon from table 1. Following is the query which I am trying to use which doesnt give any result.

 Select b.bg_id
 from table1 a,table2 b
 where a.store_id = '74073'
 AND SDO_Relate(a.geometry,b.geometry,'mask=anyinteract')='TRUE';

What would be wrong here?

  • try it without the line: where a.store_id = '74073' Do you still get no results? – ike Dec 24 '13 at 0:28
  • Try without where clause and check if select b.bg_id from table1 where store_id = '74073' giving you any row? – Ashutosh Agrawal Aug 26 '15 at 18:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.