Hi, I'm experimenting with virtual layers and struggle again with the (un)logic of that.
SELECT a.geometry,a.fid,a.typ,a.kasten_nr,a.kastenart,a.zielart,a.revier,a.gebiet,b.bemerkung,b.status,b.zustand,b.massnahmen,b.reinigung FROM (SELECT * FROM Kaesten where Kaesten.status=1 AND Kaesten.typ="BI") as a LEFT JOIN kastenkontrolle as b ON a.kasten_nr= b.kasten_nr WHERE b.kasten_nr IS NOT NULL AND b.status="nv" ORDER BY a.kastenart desc; I'm joining a subset of points with a subset of a non-spatial table. Now I would like to have the resulting attribute table be ordered, but whatever I try, the thing follows some inner will and wont order. Is ORDER BY not supported or do I miss sth basic? Thankful for any input, Bernd _______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
