How to organize a relationship between two tables?

Question

MySQL

How to make a query to organize a relationship between two tables? those. if the id_group column of table 1 contains the number 1 , then automatically substitute the name_group from table 2.

Here is a larger image link

Answer 1

In addition to the above, I recommend reading here www.mysql.ru/docs/man/JOIN.html . Syntax description with examples.