Reading from access and if id found in table 1 append Yes to Table 2 else no

Hayashi87Hayashi87 Member Posts: 4 Contributor I
edited December 2018 in Help

I am trying to read from 2 access table. Is there a function that states if id is found in table 1 , Append and add a new column in Table 2 (the main customer table), else not found set to No in table 2?

 

 

Answers

  • kaymankayman Member Posts: 662 Unicorn

    Not sure if I completely understand your request, but one way to check if an id is in one table but not in the other would be to use the 'Set minus' operator. You will then have a set with records that are not in your table, so you can use that outcome to append them.

Sign In or Register to comment.