Create a new table
Select *
From MIS.Dbo.Company_Staff_Property
union all
Select *
From MIS.Dbo.Applicant_Staff_Property Hi from the above union I want to create a new table called Staff_Properties is it possible to do this
Imran Javed Zia
Sure, you can use wraper qury to do so. And then you can use it as per requirements
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You may use the below given query to create a new table
Select * from New_table_name from
(
Select *
From MIS.Dbo.Company_Staff_Prop
union all
Select *
From MIS.Dbo.Applicant_Staff_Pr
) a
Select * from New_table_name from
(
Select *
From MIS.Dbo.Company_Staff_Prop
union all
Select *
From MIS.Dbo.Applicant_Staff_Pr
) a
Select * from Staff_Properties from
(
Select *
From MIS.Dbo.Company_Staff_Prop
union all
Select *
From MIS.Dbo.Applicant_Staff_Pr
) a
(
Select *
From MIS.Dbo.Company_Staff_Prop
union all
Select *
From MIS.Dbo.Applicant_Staff_Pr
) a
ASKER
Awesome service