只是我有两个表ForecastBackup
,ForecastTotal
我想从ForecasTotal
表中选择 4 列并插入到ForecastBackup
例如 ForecastTotal
UCPVol UCPVal IBNSINAVol IBNSINAVal
1 1 NULL NULL
2 3 NULL NULL
NULL NULL 1 4
NULL NULL 3 5
NULL NULL 1 6
我想插入ForecastBackup
非空值我的意思是结果应该是
UCPVol UCPVal IBNSINAVol IBNSINAVal
1 1 1 4
2 3 3 5
NULL NULL 1 6
我使用了这个 SQL 命令但不起作用
INSERT INTO
ForecastBackup (UCPVol,UCPVal,IBNSINAVol,IBNSINAVal)
SELECT (select UCPVol,UCPVal from ForecastTotal where UCPVol is not null),
(select IBNSINAVol,IBNSINAVal from ForecastTotal where IBNSINAVal is not null)
from ForecastTotal
这可能吗 ?
根据您的输入和输出,我认为您需要此查询
INSERT INTO ForecastBackup (UCPVol,UCPVal, IBNSINAVol, IBNSINAVal)
SELECT
A.UCPVol, A.UCPVal, B.IBNSINAVol, B.IBNSINAVal
FROM
ForecastTotal A
LEFT JOIN
ForecastTotal B ON A.UCPVal = B.IBNSINAVol
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句