Combining strings of two bases by matching words?

Question

SQL

There are two sql bases, with statistics (one main, the second auxiliary).
The format of the first: 895 903, 'Jake_Sanchez', 'c682581cf89fbd9a2ea2ed80266725b5' ,
the format of the second: ( 'c682581cf89fbd9a2ea2ed80266725b5', 'Glodiolus')
It is necessary to combine the two databases so that the second line is connected to the first one by coincidence code MD5 c682581cf89fbd9a2ea2ed80266725b5
I would be very grateful for the help .

Answer 1

There are a lot of options, if under the connection we are talking about supplementing the field of the first table with information from the field of another, then in this case you can cycle through the fields of the first table one by one, then searching for such an md5 field in the second.
As an option, first find the intersection of such fields, and then supplement with information through the cycle. There are also other ways