Join Table in 2 different database files
-
Hi all~ How do I write a Sql Statement that joining 2 tables which in 2 different database files respectively? Thanks
-
In SQL Server to access table in different database use
database_name.dbo.table_name
Work hard and a bit of luck is the key to success.
You don`t need to be genius, to be rich.
Oh Iam sorry. I miss to mention. I would like to write a sql statement that can join 2 tables and 1 is assoicated by one connection and 1 is assoicated by another connection. Is it suitable to use "database_name.dbo.table_name" with SQL Ce Server 2000? Also what is the database name and dbo? Can I get some examples? Thanks
-
Oh Iam sorry. I miss to mention. I would like to write a sql statement that can join 2 tables and 1 is assoicated by one connection and 1 is assoicated by another connection. Is it suitable to use "database_name.dbo.table_name" with SQL Ce Server 2000? Also what is the database name and dbo? Can I get some examples? Thanks
I don`t know if it's suitable with SQL Ce Server. If your database name is db1 and your table name is table1, to access the field field1 in the table use:
db1.dbo.table1.field1I hope this helps.:)
Work hard and a bit of luck is the key to success.
You don`t need to be genius, to be rich.