Stack Exchange network consists of 178 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I want to join two tables. The second table has only one row. I want to append this row to every row of table 1. How can I achieve that with SQL in QGIS3?
Create a "Virtual Layer" (Layer Menu > Create Layer > New Virtual Layer...) and use this query:
SELECT * FROM table1
LEFT JOIN table2
Then you can export as another format.
You can use "Vector general > Execute SQL" tool.
Select "No geometry", specify a file path and use this query: