我有一个表格:
+---------+------+---------+
| Col1 | Col2 | Col3 |
+---------+------+---------+
| PersonA | $10 | PersonB |
| PersonC | $20 | PersonD |
+---------+------+---------+
我希望得到以下类似的结果:
+---------+-----+-----+
| Col1 | Db | Cr |
+---------+-----+-----+
| PersonA | 0 | $10 |
| PersonB | $10 | 0 |
| PersonC | 0 | $20 |
| PersonD | $20 | 0 |
+---------+-----+-----+
是否有不使用Union all
的方法?
UNION ALL
?在这里似乎是正确的工具... - sticky bit