3 Replies Latest reply: Nov 27, 2016 9:50 PM by jade wind RSS

    list values where values from the other field are not in another table

    jade wind

      Hi everyone,

       

      I think this should be an easy one but I still cannot find a way to do it.

       

      I have two tables linked by ID field. Table1 is about the basic information of the IDs, and Table2 is a transaction table. There is a Region field in Table1. There are various other fields in both tables. 

       

      I wish to list out the Regions where none of the IDs from these Regions has ever shown up in Table2.

       

      How do I do it?

       

      Thanks in advance for any help!