Create View from another View
Database
2
Posts
2
Posters
3
Views
1
Watching
-
Hi, I have a SQL Server database with some views. If I wanted to create a new view based on a current view what is the process please? Is their issues with interrogating the same table from two views? Thanks in advance
Treat the view as just another table, you can have multiple joins to the same table/view in any view. Where there may be an issue is when you self reference via a chain of joins but MSSQL will tell you when you try and run the query.
Never underestimate the power of human stupidity RAH