SOLVED
RECORD CHECKING IN TWO TABLE
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kathbanc
8 - Asteroid
‎06-16-2023
06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI!
I have two tables with the same column.
My output should be , to display record that are not exist in TABLE A ( Reference Table). thank you in advance
Solved! Go to Solution.
Labels:
2 REPLIES 2
ScottLewis
11 - Bolide
‎06-16-2023
06:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Join the two tables on NAME with table A as the left input and table B as the right input. The Right Output Anchor of the Join will contain the records in B that were not also in A.
‎06-16-2023
07:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank @ScottLewis! It works.
