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.
| Author |
Topic |
|
neil_akoga
Yak Posting Veteran
56 Posts |
 Posted - 2008-12-18 : 11:03:34
|
| ok, this is probably obvious but i'm having a total brain fartwhat i wanna do is select from 2 tables into one view e.g. table1ideventeventTexttable 2idexternalEventeventTextso the 2 tables i'm selecting from don't need to be linked but they both have similar column data that could be concatenated into viewis this possible? |
|
|
neil_akoga
Yak Posting Veteran
56 Posts |
Posted - 2008-12-18 : 11:06:10
|
| i feel like an idiot, i totally forgot about union. somebody close this topic please :) |
 |
|
|
|
|
|
combined select