How to correctly form a query for obtaining values ​​from two tables?

Question

MySQL

Hello, is it possible with a MySQL query from two tables:

1. 
   
2. 
   

Get table like:

Answer 1

if the list of field_id values ​​is unknown in advance, then it will not work out in any way.
unless on the client to select these values ​​​​and, based on their set, build a monstrous query with a bunch of cases