How to update only empty fields in the table?

Hello.
Help to find the query
There are two tables `fanfield` and `bser`
in these tables there are fields id and value
the table `fanfield` field value is not completely filled there is an empty value
What kind of request it is possible to only update empty value from table `bser` and so to id tables ==?
June 10th 19 at 16:30
1 answer
June 10th 19 at 16:32
Solution
Some things depend on the DBMS, because I give not a recipe, but an idea
fanfield update set value = (select value from bser where id = fanfield.id) where value = ";
Received.. thank you. - Aurelie_Gerhold commented on June 10th 19 at 16:35

Find more questions by tags SQL