Pull data from database from multiple tables?

Question

MySQL

How to do it all? Already the head does not understand)))
How to make a query so that data from different tables is displayed.

DB - u0815268_scr
tables - wpps_users (from here we take the name display_name), wpps_custom_field_metas (from here we take the field_value)

This is displayed on the page.

Answer 1

JOINs will help.
LEFT JOIN, INNER JOIN, RIGHT JOIN etc.