How to check one data contained by another table
Hello,
I have two tables both containing country info. Format of TABLE1 is “Bulgaria; Denmark; Estonia; Finland;” and the TABLE2 is just columns with country names like;
Bulgaria
Denmark
Estonia
Finland
I want to check whether one of the values on TABLE1 is included on the TABLE2 how can i check that?