• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Create a new table

Select * 
From MIS.Dbo.Company_Staff_Property
union all
Select * 
From MIS.Dbo.Applicant_Staff_Property	

Open in new window


Hi from the above union I want to create a new table called Staff_Properties is it possible to do this
0
Davesm
Asked:
Davesm
1 Solution
 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
Sure, you can use wraper qury to do so. And then you can use it as per requirements
0
 
Kakhaber SiradzeCommented:

select *
into 
Staff_Properties
from 
(
Select * 
From MIS.Dbo.Company_Staff_Property
union all
Select * 
From MIS.Dbo.Applicant_Staff_Property)a

Open in new window

0
 
kumarnimavatCommented:
You may use the below given query to create a new table

Select * from New_table_name from
(
Select *
From MIS.Dbo.Company_Staff_Property
union all
Select *
From MIS.Dbo.Applicant_Staff_Property
) a
0
 
kumarnimavatCommented:
Select * from Staff_Properties from
(
Select *
From MIS.Dbo.Company_Staff_Property
union all
Select *
From MIS.Dbo.Applicant_Staff_Property
) a
0
 
DavesmAuthor Commented:
Awesome service
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now