Collections:
Creating a View with Data from Multiple Tables in SQL Server
Can You Create a View with Data from Multiple Tables in SQL Server?
✍: FYIcenter.com
Can You Create a View with Data from Multiple Tables? The answer is yes. A view can be created with a SELECT statement to join data from multiple tables.
It is a common practice to normalize data into multiple tables. Then using a view to de-normalize them into a single output.
The tutorial exercise below shows you how to create a view to normalize data from two tables SalesOrderHeader and Customer in the sample database AdventureWorksLT.
USE AdventureWorksLT; GO CREATE VIEW SalesOrderView AS SELECT o.SalesOrderNumber, o.OrderDate, o.TotalDue, c.FirstName, c.LastName, c.CompanyName FROM SalesLT.SalesOrderHeader o, SalesLT.Customer c WHERE o.CustomerID = c.CustomerID GO SELECT TOP 10 SalesOrderNumber, TotalDue, CompanyName FROM SalesOrderView; GO SalesOrderNumber TotalDue CompanyName ---------------- ----------- ------------------------------ SO71915 2361.6403 Aerobic Exercise Company SO71938 98138.2131 Bulk Discount Store SO71783 92663.5609 Eastside Department Store SO71899 2669.3183 Coalition Bike Company SO71898 70698.9922 Instruments and Parts Company SO71902 81834.9826 Many Bikes Store SO71832 39531.6085 Closest Bicycle Store SO71776 87.0851 West Side Mart SO71797 86222.8072 Riding Cycles SO71895 272.6468 Futuristic Bikes
⇒ Creating a View with Data from Another View in SQL Server
⇐ sys.sql_modules - Getting View Definitions Back in SQL Server
2016-11-05, 2323🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...