我正在使用Microsoft Office访问,并且有一个任务要将表移到另一个表并更改列值。
我有这样的表:
ID NAME DIRECTOR UNIVERSITY
1 Banana Apple KTU
2 Pear Orange KTU
3 Tomato Cucumber VU
我还有另一个:
ID UNIVERSITY
1 KTU
2 VU
我正在尝试做的就是将新表插入新文件,如下所示:
ID NAME DIRECTOR UNIVERSITYID
1 Banana Apple 1
2 Pear Orange 1
3 Tomato Cucumber 2
我的SQL代码如下所示,但并没有得到我想要的结果:
INSERT INTO Fakultetas IN 'C:\Users\NeuTronas\Desktop\NaujaDB.accdb'
SELECT DISTINCT a.[Unikalus ID] AS ID,
a.Pavadinimas AS Pavadinimas,
a.Dekanas AS Dekanas,
a.Lokacija AS Lokacija,
b.ID AS UniversitetoID
FROM Fakultetas AS a
INNER JOIN [C:\Users\NeuTronas\Desktop\NaujaDB.accdb].Universitetai AS b
ON a.Universitetas = b.Univesitetas;
它的表有些不同,但是如果像示例中的那样,它将是:
INSERT INTO NewTableName IN 'C:\Users\NeuTronas\Desktop\NaujaDB.accdb'
SELECT DISTINCT a.ID AS ID,
a.Name AS Name,
a.Director AS Director,
a,
b.ID AS UniversityID
FROM OldTableName AS a
INNER JOIN [C:\Users\NeuTronas\Desktop\NaujaDB.accdb].SecondTableName AS b
ON a.Universitetas = b.Univesitetas;
我不确定您真正要寻找的是什么,但是您可以执行以下操作:
SELECT a.ID, a.NAME, a.DIRECTOR, b.UNIVERSITYID
INTO FakultetasTemp
FROM Fakultetas a
INNER JOIN SecondTableName b
ON a.Universitetas = b.Univesitetas
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句