I have a relation from DATA Table to geo point. Now I want to remove all odd geo points without relation from data table? How can I do it from the backendless web console?
I need to run SQL like this:
DELETE FROM GeoCategory WHERE id NOT IN ( SELECT t.id FROM ( SELECT d.id FROM mydata d LEFT JOIN GeoCategory geo ON geo.id = d.geo ) as t );