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!