5 Replies Latest reply: Apr 29, 2015 5:32 PM by Marcelo Fonseca RSS

    Exclude table lines based on other tables

      Hi Guys!

       

      I have two tables like the examples below. I need to exclude the IDs from table 2 that do not belong to the table 1, after already load this 2 tables. Table 1 i get from SharePoint and table 2 from a SQL server.

       

      Table 1

      IDDate
      ABC101/03/2015
      ABC204/05/2014
      ABC303/05/2014
      ABC420/06/2014
      ABC515/09/2014

       

      Table 2

      IDDate
      ABC115/09/2014
      ABC120/06/2014
      ABC503/05/2014
      ABC2004/05/2014
      ABC3001/03/2015
      ABC3504/05/2014

       

       

      So i expect to have the result below in the table 2, considering that my ID in table 2 can repeat:

       

      IDDate
      ABC115/09/2014
      ABC120/06/2014
      ABC503/05/2014

       

      Can you please suggest a solution?

       

      BR//Marcelo Fonseca