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
DavesmAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kakhaber SiradzeConnect With a Mentor Commented:

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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.