oracle 不同版本sql执行问题
merge into salm031_regstatus salm031
using (select '107' posno,
nvl(salm030_posip, ' ') salm030_posip,
'20120822',
'20120822103131',
'000024'
from dual
left join salm030_regconf
on salm030_posno = '107') salm
on (salm031_posno = posno)
using (select '107' posno,
nvl(salm030_posip, ' ') salm030_posip,
'20120822',
'20120822103131',
'000024'
from dual
left join salm030_regconf
on salm030_posno = '107') salm
on (salm031_posno = posno)
这段sql 中 salm031_posno = posno 要用别名,不能用 常量,不然会报错