阅读背景:

使用TableC的不同列值更新TableA,需要使用哪些列值在TableB中配置

来源:互联网 

Table Structure

TableA
+---------+--------+--------+
| ColA1   | ColA2  |  ColA3 |
+---------+--------+--------+
|  1      |  B1    |        |
+---------+--------+--------+
|  2      |  B2    |        |
+---------+--------+--------+

TableB
+---------+--------+--------+
| ColB1   | ColB2  |  ColB3 |
+---------+--------+--------+
|  1      |  B1    |  ColC2 |
+---------+--------+--------+
|  2      |  B2    |  ColC3 |
+---------+--------+--------+


TableC
+---------+--------+--------+
| ColC1   | ColC2  |  ColC3 |
+---------+--------+--------+
|  1      |  100   |  1000  |
+---------+--------+--------+
|  2      |  200   |  2000  |
+---------+--------+--------+
TableA
+---------+--------+--



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: