1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

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

  1. Feb 22, 2015 #1

    WWGD

    User Avatar
    Science Advisor
    Gold Member

    1. The problem statement, all variables and given/known data
    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.

    2. Relevant equations


    3. The attempt at a solution
    Doing a query on 3 tables, I am getting redundancy. No idea what else to do.
     
  2. jcsd
  3. Feb 23, 2015 #2

    Svein

    User Avatar
    Science Advisor

    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.
     
  4. Feb 23, 2015 #3

    WWGD

    User Avatar
    Science Advisor
    Gold Member

    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?
     
  5. Feb 23, 2015 #4

    Svein

    User Avatar
    Science Advisor

    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.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted



Similar Discussions: Queries in ACESS (QBE) : Can we use more than 3 Tables?
Loading...