I use QGIS 3.4 on Windows 10
I have a polygon layer and a point layer. The points have a streetname attribute. I want to check if there are polygons with more then 1 streetname.
I took 2 steps, first Join attributes by location to get the streetnames as attribute in the polygons. The second step is a self join in a virtual layer
SELECT T1.POLid, T1.Postalcode, T1.streetname, T2.streetname
FROM TestStreet AS T1, TestStreet AS T2
WHERE T1.POLid = T2.POLid AND T1.streetname <> T2.streetname;
I have to interrupt the processing after waiting very long.
My workaround is:
Save features As csv file
Import csv file in MSAccess
MSAccess gives instantaneous results with the same query.
What is it what I do wrong in QGIS, is there a better way just with QGIS?