query mysql

you need to construct the correct query for mysql, the essence of the problem – there is 2 tables, they have a common field product_id.... you need to make a selection from the first table, and to assign these records a value in column 2 of table.... the query I made but why is it not RA