Yes. In Access terminology the data are contained in tables while a database contains tables, queries, forms etc. The only requirement for multi-table queries is a field that can be used to link tables pairwise.WWGD said:Thanks, so in principle it is possible to query more than two databases ? Do we need any pair or any n-ple of databases to be related?
Yes, it is possible to use more than 3 tables in a single query in Access QBE. However, it is not recommended to use too many tables in a single query as it can make the query more complex and difficult to manage.
There is no specific limit to the number of tables that can be used in a query in Access QBE. The limit will depend on the complexity of the query and the resources available on the computer running the query.
The best way to use multiple tables in a query in Access QBE is to first determine the relationship between the tables and then use appropriate join types (such as inner join or outer join) to combine the data from the tables.
Yes, it is possible to use tables from different databases in a single query in Access QBE. However, the databases must be linked in order to access the tables from the other database.
No, it is not possible to use tables with no common fields in a query in Access QBE. In order to combine data from multiple tables, there must be at least one field that is common between the tables to establish a relationship.