I have a table with some null values in column "date":
platform date id
---------------------------
web 2018-10-10 1
mob 1
mob 1
web 2018-10-15 2
mob 2
ntl 2018-10-09 3
web 2018-10-12 3
web 2018-10-11 4
mob 3
I want to update null values in 'date' for 'mob' platform by matching the 'id' column from platform 'web'. The result should look like this:
platform date id
---------------------------
web 2018-10-10 1
mob 2018-10-10 1
mob 2018-10-10 1
web 2018-10-15 2
mob 2018-10-15 2
ntl 2018-10-09 3
web 2018-10-12 3
web 2018-10-11 4
mob 2018-10-12 3
Will really appreciate your help!