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
);
Thank you.