테이블에서 테이블 만들기

다른 table에서 값 가져오기

 

 

 

 

방법1.

--1.
insert into test5
select BusinessEntityID, FirstName, LastName
from AdventureWorks2019.Person.Person

 

2.

--2.
select BusinessEntityID as id, FirstName as Fname, LastName as Lname
into test6
from AdventureWorks2019.Person.Person