Bosses, consult the SQLite statements, can achieve the following functions?
To open a database: C: \ a.s cindex
Then attach the another database
The attach 'c: \ b.s cindex' as' test1 ';
False original query is
SELECT * FROM COMPANY INDEXED BY ID_index WHERE (ID='456789 ABC COLLATE NOCASE);
After the link how to write the query two databases?
Two tables in the database names are COMPANY, structure is completely the same, both have indexes ID_index
CodePudding user response:
Because want to use sorting, so it's best to a query