如何将多个表中的值插入单个表?

问题描述

我有3张桌子.我需要将第一个表中的3列值和第二个表中的1列值插入3third表.

I have 3 tables. i need to insert 3 column values from first table and 1 column value from second table into 3third table. what is the query for that????

推荐答案

insert into table3 (field1, field2, field3)
select column1, column2, column3 from table1 t1 join table2 t2 on t1.table_id = t2.table_id

SELECT Persons.LastName,Orders.OrderNo
INTO Persons_Order_Backup
FROM Persons
INNER JOIN Orders
ON Persons.P_Id=Orders.P_Id

在此处详细了解有关选择的信息. [ ^ ]

Read more about select into here[^]

这篇关于如何将多个表中的值插入单个表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！