I created an innerjoin as part of spatial view. It succeeded without issue and loaded the result into QGIS. The resulting table and multipolygons displayed the same data for all 970 records and treated the table as if it was only 1 record. When I view the spatial view inside the plugin all records display correctly. I don't know if this is a qgis issue or qspatialite.
SELECT buildings._, buildingaddresses.
FROM buildings
INNER JOIN building_addresses
ON buildings.Label = building_addresses.FacilityNumber;
buildings is mulitpolygon
building_addresses is a table
I created an innerjoin as part of spatial view. It succeeded without issue and loaded the result into QGIS. The resulting table and multipolygons displayed the same data for all 970 records and treated the table as if it was only 1 record. When I view the spatial view inside the plugin all records display correctly. I don't know if this is a qgis issue or qspatialite.
SELECT buildings._, buildingaddresses. FROM buildings INNER JOIN building_addresses ON buildings.Label = building_addresses.FacilityNumber;
buildings is mulitpolygon building_addresses is a table