How to relate two tables in different data base
-
Mine query is I have two data bases db1 and db2. db1 contains one table name country and db2 contains one table contact. in db1.contact table it has one field country_code and same in db2.country table country_code. can you give me the solution for it,I want to show country name. but in contact table only it has country_code.
-
Mine query is I have two data bases db1 and db2. db1 contains one table name country and db2 contains one table contact. in db1.contact table it has one field country_code and same in db2.country table country_code. can you give me the solution for it,I want to show country name. but in contact table only it has country_code.
Which type of database are you using? (MSSQL, MySQL, Access, Etc) See link below: Google Search Results for "join tables from different databases" This may be the wrong place to ask this question. More database related :doh: Green2Go