看图操作,如果需要sheet3表中的所有数据,去掉最后的“WHERE T2.B Between 1639931800 And 1639932498”即可 SELECT IIf(T1.PNR Is Null,T2.A,T1.PNR) AS PNR, IIf(T1.票号头 Is Null,T2.B,T1.票号头) AS 票号头, IIf(T1.票号 Is Null,T2.C,T1.票号) AS 票号, IIf(T1.票面价 Is Null,T2.D,T1.票面价) AS 票面价, IIf(T1.税1 Is Null,T2.E,T1.税1) AS 税1, IIf(T1.税2 Is Null,T2.F,T1.税2) AS 税2, IIf(T1.日期 Is Null,T2.G,T1.日期) AS 日期 FROM [Sheet3$] T2 LEFT JOIN [销号$] T1 ON T2.B = T1.票号 WHERE T2.B Between 1639931800 And 1639932498
nsG65mXK.rar
(56.32 KB, 下载次数: 0)
|