I have a table_1 with root domain urls (ex : cnn.com) and i’d like to do a check for each row in order to see if :
a) i’ve never contacted the website
b) i’ve already contacted and got a positive answer
c) i’ve already contacted and got a negative answer
I have a table_2 with the contact history
Is it possible to automatically check for a value in table_2 and based on that display something in table_1?
Many thanks for your help.