如何把left join查询后的数据存入临时表中？

Question

left join语句如下
SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
LEFT JOIN Orders
ON Persons.Id_P=Orders.Id_P
ORDER BY Persons.LastName

Answer 1

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo into #tempTable
FROM Persons
LEFT JOIN Orders
ON Persons.Id_P=Orders.Id_P
ORDER BY Persons.LastName