且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从两个表中查找并将重复的行插入到临时表中

更新时间:2022-12-12 13:50:14

LR_NoLr_Date 等.可能同时存在于两个表中,并且您正在编写

FROM TrnBal,ullr

Select语句中,将导致上述错误.

因此,为两个表中的columns 指定Table ,例如

Select TrnBal.LR_No, TrnBal.Lr_Date
The columns LR_No, Lr_Date etc. may be present in both the tables and you are writing

FROM TrnBal,ullr

in the Select statement, which gives rise to the above error.

So specify the Table for the columns which are present in both tables, say

Select TrnBal.LR_No, TrnBal.Lr_Date