Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2016
    Posts
    2

    multi table queries

    Dear users
    hi
    i am omid and i have a question at the back of my mind that i can not solve and here
    it is
    how is a query that is composed of more than three tables evaluated?.i
    can figure out the result of a query that is composed of two tables


    using set theory(considering joins) but what about a query that has more than three
    tables (considering joins)?
    i have run some tests in access but i am not quite sure
    best regards

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    3 table will pull and display what you put in the query grid.
    depending on the joins ,you can get different results.

  3. #3
    Join Date
    Jul 2016
    Posts
    2
    Quote Originally Posted by ranman256 View Post
    3 table will pull and display what you put in the query grid.
    depending on the joins ,you can get different results.
    is the query made from left to right according to joins?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-21-2015, 07:04 AM
  2. Replies: 8
    Last Post: 05-08-2014, 12:07 PM
  3. Multi-Table Queries (Where to Start?)
    By dccjr in forum Queries
    Replies: 1
    Last Post: 04-23-2013, 06:34 PM
  4. Replies: 1
    Last Post: 02-18-2013, 02:55 AM
  5. What's the purpose of multi key for one table?
    By latestgood in forum Access
    Replies: 3
    Last Post: 07-01-2011, 12:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums