Hi there,
I have two tables Table1 and Table2, I want to update those x and y in Table 1 with a and b in Table 2, where ID of Table 1 is matching with ID of Table 2 and z in Table 1 is Null.
Please tell me how to write the expression for this ?. Thanks and Regards.
ID x y z 1 5543 534 543 2 7546 34 54 3 7645 34 245 4 234 234
5 65 456
6 234 5653
7 465 653
ID a b c 1 7 7
2 7 7
3 7 7
4 7 7
5 7 7
6 7 7
7 7 7