Hi !
One of my tables lacks information that another table contains, telephone number
for example.
I'd like to update the column "Telephone" of table b wherby table a.
in the code:
select
a.telephone
b.telephone
from
t1 as a full join t2 as b
on
a.id=b.id
whenever t2 has an empty cell it should be updated and set with t1's value.
Can anyone show me how it can be done ?
Thanks !