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 |
|
friscapjtn
Starting Member
8 Posts |
 Posted - 2009-09-02 : 02:52:46
|
| Hello,I've got a strange problem. I can't create a view with a query containing a UNION statement.e.g:create view test asselect a.name, a.telephone, a.birthday, b.address, b.status,c.divisifrom test1 a left outer join test2 b on a.id = b.idleft outer join test3 c on a.id = c.idhow i can union this view test with test1 and test2? Hmmm.... |
|
|
Sachin.Nand
2937 Posts |
Posted - 2009-09-02 : 03:35:48
|
| Does it give any error?PBUH |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-02 : 04:01:15
|
I don't see any union in your create statement and I don't see any reason for an union.Could you explain more clear please?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-02 : 04:23:24
|
| Note that the number of columns and datatypes should match if you use UNION or UNION ALLMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Create View Union