Results 1 to 4 of 4
  1. #1
    AnneForumer is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    20

    How to add a field from another table in a self-join query?

    I have a three level self-join that is working fine. This query uses the same table, A, three times.



    I'd also like to add another field from another table, B, to the output of the self-join query. Tables A and B can be joined on a field. I tried to create a query, qryC, joining tables A and B and do a self-join on qryC but it's not working.

    I'd appreciate any help in accomplishing this.

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Please show us your database design (relationships window) as jpg.
    Tell us more about your self join in business terms.

  3. #3
    AnneForumer is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    20
    Thank you for your quick response!

    The first self-join query, using only table A, works. Then I create a query with table A joined to table B and use this query in self-join shown in the last picture and it doesn't produce any results. Being a many to many situation, I don't want to include the desired additional field, DataSubjectName, in table A.

    Thanks

    Click image for larger version. 

Name:	SelfJoinQueries.jpg 
Views:	6 
Size:	101.5 KB 
ID:	25591

  4. #4
    AnneForumer is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    20
    Please ignore my question. Self-join with query is working. There was problem with my underlying data. Your question prompted me to explore it further.

    Thanks!

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

Similar Threads

  1. Join A Field In One Table to Two Fields In Another Table
    By Aaron5714 in forum Database Design
    Replies: 3
    Last Post: 05-10-2014, 02:56 PM
  2. Query table join question
    By Nelson8 in forum Queries
    Replies: 1
    Last Post: 07-26-2013, 08:08 AM
  3. Adding records to a join table using a query
    By brharrii in forum Queries
    Replies: 5
    Last Post: 04-12-2013, 11:08 AM
  4. Replies: 1
    Last Post: 12-02-2010, 04:54 PM
  5. How does Access guess join field in query?
    By bar tomas in forum Database Design
    Replies: 1
    Last Post: 05-27-2009, 05:56 PM

Tags for this Thread

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