Menu
SQLITE
I have 2 tables "Source" and "Destination" that have the same fields. ID and COUNTRY, though they both have other fields too that are not in common.
I need to copy the Source.Country value to the Destination.Country where the join is on ID
For the life of me I can't make Sqlite do this.
In SQL Server etc this is a super simple task.
Ideas?
552
Syntax. The syntax for the SQLite CROSS JOIN is: SELECT columns FROM table1 CROSS JOIN table2; NOTE: Unlike an INNER or OUTER join, a CROSS JOIN has no condition to join the 2 tables.
The current version of SQLite handles multiple connections through its thread-mode options: single-thread, multi-thread, and serialized. Single-thread is the original SQLite processing mode, handling one transaction at a time, either a read or a write from one and only one connection.
INSERT INTO Destination SELECT * FROM Source; See SQL As Understood By SQLite: INSERT for a formal definition.
88
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
