Andy Wilbourn
2010-01-27 13:51:50 UTC
If you have used the ATTACH statement you just use your alias you defined
So something like this:
1. Open connection to first database
2. Run command to attach another database ATTACH 'c:/mydata/db2.db'
AS db2
3. Run query that joins two together, just need to use syntax of <db
alias>.<table>. So something like db2.table1 for instance of having a table
in database 2 that is named table1.
So something like this:
1. Open connection to first database
2. Run command to attach another database ATTACH 'c:/mydata/db2.db'
AS db2
3. Run query that joins two together, just need to use syntax of <db
alias>.<table>. So something like db2.table1 for instance of having a table
in database 2 that is named table1.