You could also do a SELECT *, or further restrict the columns you want to see.
You can also add additional row restriction to the view as we have done.
As you can see from the examples below, we can use this view in a variety of different ways.
Note that for each scenario that we did not need to join any tables.
IF ( OBJECT_ID('dbo.vw_occupied_seats_by_class') IS NOT NULL ) DROP VIEW dbo.vw_occupied_seats_by_class GO CREATE VIEW dbo.vw_occupied_seats_by_class AS SELECT a.course_designater_fk , b.seat_num , (c.firstname ' ' c.lastname) as "Student" FROM dbo. Class Registration b ON a.classes_num = b.classes_num JOIN dbo.
Students c ON c.student_id = b.student_id_fk GO Above is a simple view that provides us with a listing of occupied/unoccupied seats for our classes.
If you change your View, like adding or removing a column, you will need to fetch the changes in the View into SQL Spreads.
You do that by closing and re-opening the SQL Spreads Design mode by clicking the Design mode button in the SQL Spreads ribbon in Excel.
A view is really nothing more than a logical representation of one or more tables in a database.Introduction As I wrote in the previous article, you can update records via a view in SQL but there are some restrictions, for example you can't update records in multiple tables when the view references more than one base table.