Mysql + php how to get the value of the third column by comparing the other two in two different tables?

Question

PHP

Good day to all. Faced such a problem. I have 2 tables in the database, one stores data about the site visitor (ip, ISO-code of the country ...). The second table has a column for the country's ISO code and a column for the ISO code. I need the ISO-code of the country from the first table to find the same value in the second, but the decoding of the code would be displayed on the screen. If someone has come across this and found a solution, tell me or throw a link where you can read about it.

Answer 1

it's time to discover the JOIN operator