T034 和T039是现在的表 T034_2021 T039_2021是历史表字段都是相同的 怎么加 有人教教么。
WITH ZZXZTCX AS (
SELECT
T034D001,
T034D002,
T034N005,
T034N047,
T034N048,
T034N001,
T034I001,
T034N030,
T034N031,
T034N050,
T034N059,
T034N051,
T034N036,
T034N037,
T034N039,
T034N040,
T013C001,
T034N035,
T034D006,
T034D007,
T034C002,
T034C006,
T021N002,
T034N043,
T039D001,
T039D002,
T039N043,
T039C002,
T039C006,
T039N072
FROM
T034
LEFT JOIN T013 ON T034N028 = T013N001
LEFT JOIN T021 ON T034N056 = T021N001
LEFT JOIN T039 ON T034N001 = T039N002
WHERE
1 = 1
AND T034N054 = '5B83E5B8-D7F2-40D4-8BE6-3D011DDA07DA'
AND T034N055 = '拣货'
AND T034N059 IS NOT NULL
AND (T034D001 >= @KSRQ or T039D001 >= @KSRQ)
AND (T034D001 <= @JSRQ or T039D001 <= @JSRQ)
--AND T039D001 >= @KSRQ
--AND T039D001 <= @JSRQ
AND T034N047 =@T034N047
AND T034N059 LIKE '%' +@T034N059 + '%'
AND T034N030 LIKE '%' +@T034N030 + '%'
AND T034N031 LIKE '%' +@T034N031 + '%'
AND T034N044 =@TXXXN024
AND T034N052 = '643EEDA1-C8EA-42CA-B917-E49F5EA637E5'
AND T034N053 = '销售订单'
) SELECT
CONVERT(VARCHAR(200),T034D001,20) AS 拣货索取时间,
CONVERT(VARCHAR(200),T034D002,20)
T034N047
T034N048
T034N001
T034N005
T034N030
T034N031
T034N050
T034N051
T034N036
T034N037
T034N039
T034N040
T013C001
T034N035
T034D006
T034D007
T034C002
T034C006
T021N002
T034N043
CONVERT(VARCHAR(200),T039D001,20)
CONVERT(VARCHAR(200),T039D002,20)
T039N043
T039C002
T039C006
T034N059
T039N072
FROM
ZZXZTCX
ORDER BY
T034D001,
T039D001 DESC
用insert 语句就可以实现，问题是有没有重复的主键
insert into 表名 select 字段列表 from 表名 ，用这条语句就可以了
您好，我是有问必答小助手，你的问题已经有小伙伴为您解答了问题，您看下是否解决了您的问题，可以追评进行沟通哦~
如果有您比较满意的答案 / 帮您提供解决思路的答案，可以点击【采纳】按钮，给回答的小伙伴一些鼓励哦～～
ps:问答VIP仅需29元，即可享受5次/月 有问必答服务，了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632