View Full Version : Help On Sql

09-19-2006, 01:33 PM
Hello all,
One quick question.
Is that posibble to retrive records from two separate databases at the same time? IF yes how? Could you please post a sample query.

09-19-2006, 07:00 PM
Database names can prefix table names, just like table names can prefix column names, using a dot (.) in each case:


The default database, selected with either the USE command, or upon connection to the database server, helps simplify access by allowing that database name to be omitted in queries.

It should be noted that trying to access, and certainly trying to join, two tables in different databases is probably unwise. A database should encapsulate an entire set of entity relationships. In some DBMS, database separation is strictly enforced (such as in PostgreSQL).


09-20-2006, 01:36 PM
Though MS-Access has lots and lots of limitations as a database it offers linking of tables of different databases.

Using this feature one can use a table which is actually not a part of its database, as if it is a part of that database.