![]() ![]() ![]() ![]() |
|||||
|
|||||
樓主 HB ![]()
![]() |
Google尋求的方法如下: https://stackoverflow.com/questions/6824717/sqlite-how-do-you-join-tables-from-different-databases 但套至下列資料庫,無法成功。 ATTACH 'N:\Data\Sys.db' as db1; ATTACH 'N:\Data\AA\Data_1.db' as db2; select f.[Type], c.[Index] from db2.[FFF] f left join db1.[Type] c on f.[Type] = c.[ Type] where f.[Type] is not Null group by f.[Type], c.[Index] order by c.[Index], f.[ Type]
搜尋相關Tags的文章:
[ SQLite 2 Database Join ] ,
本篇文章發表於2022-06-07 07:26 |