I would like to link a database with non-spatial data (it is just text and numbers) with a shapefile in QGIS. (Note: it is Microsoft SQL Server Management Studio) How do I do that?
If I am able to connect the database can I join both a specific table from SQL with the .shp file using a common ID?