我有以下選擇陳述句，我想將結果輸入到我創建的新表“additions”中。選擇陳述句在我的新表中具有相同的列
Select ThisWeek.*
from
(
SELECT table1, table 2, table 3, getdate() as Date,
FROM ...
where ....)
)ThisWeek
left outer join
(
SELECT ...
FROM .....
where ..... ) LastWeek
on .....
where Lastweek... is null
union
Select
table1,table2
getdate() as Date,
LastWeek.table1, lastweek.table2
(
SELECT...
FROM ....
....
FROM....)
)ThisWeek
Right outer join
(
SELECT table1, table 2 ....
FROM ....
where...
FROM ....] ) - 2)
) LastWeek
on ....
where ... is null
uj5u.com熱心網友回復：
如果您創建了 添加表，請使用INSERT INTO
INSERT INTO additions (column1, column2, column3, ...)
Select ThisWeek.*
from(
.....
)
您可以使用INTO語法創建添加表，如下所示：
Select ThisWeek.*
INTO additions
from(
.....
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/430060.html