How to write a SQL query for this case?

Question

MySQL

Good morning! It is necessary to write an SQL query for these tables in the
connection napravlenie ->history HASONE, the connection history->napravlenie hasMany
and the connection between checkinganaliz->napravlenie HASMANY.
I want to recycle data between history->napravlenie only hasOne, napravlenie ->checkanaliz hasMany.
For example, the type of data:

I need only 1 direction in the database, i.e. in checkAnaliz, I need to put down the id records of the first direction and then delete the repeated directions of the history case.
That is, the form should take this

Answer 1

It seems to me that your task can be formulated differently:
1. In the checkanaliz table, replace the value of the id_napravlenie field with id_history from the napravlenie
table 2. Delete records in which id <> id_history from the napravlenie table
Maybe this will prompt you to a decision, do not write a query for you really want.

Answer 2

First, update the records in the checkanaliz table:

update  checkanaliz set id_napravlenie = 1 where id_napravlenie = 2

Then delete the records from the napravlenie table: These are elementary actions that are available to you in SQL.
delete from napravlenie where id = 2