The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

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

Hayashi87Hayashi87 Member Posts: 4 Contributor I
edited November 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.