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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-17 : 19:06:40
|
Fishy writes "How do I remove the duplicate columns from the statement below:
SELECT * FROM dbo.A, dbo.B, dbo.C
-as tableA have the same column ID(ID1)
-as tableB have the same column ID(ID2)
I can retieve the data but cannot save the statement under the VIEW. If not mistaken, I think there is a keyword that I can use to eliminate the duplicate columns. Thanks." |
|
|
|
|
|
Remove Duplicate Columns