AnsweredAssumed Answered

How to compare 2 tables and put non-matching results?

Question asked by ucharles on Jan 30, 2018
Latest reply on Jan 20, 2019 by ucharles

I have 2 Tables with the same attributes: Id, name, passportNo. One of the tables is external. I want to be able to compare the two tables and display non-matching records; especially with regard to passport number. I want to be able to find out if all passport numbers are matching. How to I write a script to achieve that. I have to dig through previously asked questions but I am still unable to figure out.