Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 CREATING A VIEW

Author  Topic 

viper
Starting Member

6 Posts

Posted - 2009-10-03 : 17:06:03
Hi
I would like to gather all the data from 2 diferent tables into one view.
Both tables have the Same column names.
The table names are Internet,Machinery

Thanks

VIPER

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-10-05 : 02:46:29
Select columns from Internet
union all
select columns from Machinery


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -