Table 1:
id name desc
-----------------------
1 a abc
2 b def
3 c adf
Table 2:
id name desc
-----------------------
1 x 123
2 y 345
In prophet SQL, how would I run a sql update question that can refresh Table 1 with Table 2's name and desc utilizing a similar id? So the final product I would get is:
Table 1:
id name desc
-----------------------
1 x 123
2 y 345
3 c adf