1 Reply Latest reply on May 15, 2006 6:09 PM by The ScareCrow

    Two Joins to Single Table

    hml398 Level 1
      I need to be able to join two fields in table a with a single field in table b. I have chapterid and regionid in table a. I need to get the name of the region and the name of the chapter from the query based on the id values in table a. The problem is the structure of table b has regionid, regionname, ischapter fields instead of having a separate table for chapters. So I need to figure out a way to join chapterid in table a with regionid in table b AND regionid in table a with regionid in table b at the same time since I need it for each record. I have tried a bunch of things without success. Any ideas?

      TIA
      Heather