You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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., building_addresses.
FROM buildings
INNER JOIN building_addresses
ON buildings.Label = building_addresses.FacilityNumber;
buildings is mulitpolygon
building_addresses is a table
The text was updated successfully, but these errors were encountered:
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., building_addresses.
FROM buildings
INNER JOIN building_addresses
ON buildings.Label = building_addresses.FacilityNumber;
buildings is mulitpolygon
building_addresses is a table
The text was updated successfully, but these errors were encountered: