2 Replies Latest reply on Nov 6, 2015 5:57 PM by AnalistaMixta

    Union Query for Two Subject Areas with Join

    AnalistaMixta

      I am trying to create a union query to merge fields from two different subject areas.

       

      To simplify, this is the setup:

       

      SubjectArea1.ID

      SubjectArea1.Name

      SubjectAreas2.ID

      SubjectArea2.Sales


      The results need to show:


      ID, Name, Sales.


      The results should only include IDs that are both in the SubjectArea1 and SubjectArea2 queries.


      My union query works, but it returns all IDs from both subject areas. Using Intersect doesn't work for this since it is looks for exact records in both queries.


      How can I add the following join? SubjectArea1.ID = SubjectArea2.ID?


      Thank you for reading.