I am running on Windows 8.1 SpatiaLite_gui 1.8.0, SpatiaLite version 4.2.0 and SQLite 3.8.5.
I need to interrogate one single spatial table whith those attributes:
ID | val | val_1 | val_2 | Geom
and I'd like to get all the IDs with the same values (val, val_1, val_2) of the starter ID.
My idea was at the first place to create a view like:
CREATE VIEW test_1 AS
WHERE id = 1234
And then to select all the values from "table" with the same values (val, val_1, val_2) in the view.
Is there a way to get the same result with a single query or sub-query?