I have two tables that each have a Job Number and a Status.
Table 1: "Active Projects" columns "Job Number" and "Status"
Table 2: "BW Projects" column "BW Job NUmber" and "BW Status"
I need to write a third column in each table telling true/false whether or not there exist Job Numbers in one table but not the other, and I need to do it both ways.
Example: BW Job Number 2017-DAT-J01 does not exist in "Active projects" but exists in "BW PRojects"
Job Number 2017-DAT-J02 does not exist in "BW Projects" but exists in "Active Projects"
check if this help.
Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.