摘要： mergeintosalm031_regstatussalm031using(select'107'posno,nvl(salm030_posip,'')salm030_posip,'20120822','20120822103131','000024'fromdualleftjoinsalm030_regconfonsalm030_posno='107')salmon(salm031_posno=posno)这段sql 中 salm031_posno=posno 要用别名，不能用 常量，不然会报错 阅读全文