Queries in ACESS (QBE) : Can we use more than 3 Tables?

  • Thread starter Thread starter WWGD
  • Start date Start date
Click For Summary

Discussion Overview

The discussion revolves around querying multiple tables in a relational database using Access, specifically addressing the possibility of using more than three tables in a query and the conditions under which this can be done.

Discussion Character

  • Homework-related, Technical explanation

Main Points Raised

  • One participant expresses difficulty in querying three tables due to redundancy and seeks guidance.
  • Another participant requests more information about the tables and the specific query objectives to provide better assistance.
  • A participant questions whether it is possible to query more than two databases and whether any pair or n-tuple of databases needs to be related.
  • A later reply confirms that it is indeed possible to query multiple tables, stating that the only requirement is having a field that can link the tables pairwise.

Areas of Agreement / Disagreement

Participants do not reach a consensus on the specifics of the query or the nature of the tables involved, indicating that multiple views and uncertainties remain regarding the best approach to querying.

Contextual Notes

Limitations include a lack of detailed information about the tables involved and the specific query requirements, which may affect the ability to provide a definitive solution.

WWGD
Science Advisor
Homework Helper
Messages
7,806
Reaction score
13,120

Homework Statement


I am trying a query on a relational database. No two (related)tables have all the variables/attributes I need. I am trying to do the query on 3 tables.

Homework Equations

The Attempt at a Solution


Doing a query on 3 tables, I am getting redundancy. No idea what else to do.[/B]
 
Physics news on Phys.org
You need to give us more information, such as: what are the contents of the tables and what do you want the query to answer.
 
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?
 
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. 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.
 

Similar threads

MHB QBE Queries: Get Answers for RADL DB
  • · Replies 9 ·
Replies
9
Views
1K
Doing a Count in Access 2013 Query -- How to?
  • · Replies 3 ·
Replies
3
Views
1K
Probability Question -- Choosing red and white coins from two tables
  • · Replies 1 ·
Replies
1
Views
1K
Circuit design using switches puzzle
  • · Replies 13 ·
Replies
13
Views
3K
April Fool's Physics Papers 2026
  • · Replies 3 ·
Replies
3
Views
713
[SQL] Query using Data from 2 Tables
  • · Replies 4 ·
Replies
4
Views
2K
Using Wolfram Alpha to Create Truth Tables for Logical Statements
  • · Replies 15 ·
Replies
15
Views
3K
Python Query runs fine in MySQL, but returns empty list in Python
  • · Replies 7 ·
Replies
7
Views
6K
Writing SQL Queries: Can You Have 2 Efficient Solutions?
  • · Replies 1 ·
Replies
1
Views
2K
Three phase line or phase voltage?
  • · Replies 1 ·
Replies
1
Views
2K