![sql - How can I update table A with data from table C when A and C are linked via table B - Stack Overflow sql - How can I update table A with data from table C when A and C are linked via table B - Stack Overflow](https://i.imgur.com/7RpKBmm.jpg)
sql - How can I update table A with data from table C when A and C are linked via table B - Stack Overflow
![How would I join Table B and Table C in this scenario? Right now all the joins (black lines) are connected through table A. However I have a field in B and How would I join Table B and Table C in this scenario? Right now all the joins (black lines) are connected through table A. However I have a field in B and](https://preview.redd.it/how-would-i-join-table-b-and-table-c-in-this-scenario-right-v0-1s7din797kz91.jpg?auto=webp&s=969e58cd310840dc4d5dce78741bb31542d5b818)
How would I join Table B and Table C in this scenario? Right now all the joins (black lines) are connected through table A. However I have a field in B and
![sql server - Transact-SQL: Join two tables with optional join-attributes in Table 2 - Stack Overflow sql server - Transact-SQL: Join two tables with optional join-attributes in Table 2 - Stack Overflow](https://i.stack.imgur.com/SKi0Q.png)