SQL Tutorial 11: Create Views HD

View is another object that you could store in database. As pre-cursor in preparing reports, view is an effective simplified table from SELECT JOINed query. You don’t need to re-execute a SELECT JOIN that you have defined in the past. Once you have set the correct join, save it on a view. This video tutorial shows on how to create views from given SELECT LEFT JOINs. You may see the structure of a view as if you are describing a table. You can distinguish view from other objects inside a database as you list it with tables. It also shows the work around on how to sort in a specified ORDER BY clause and save it on a view. Normally, view does not accept script with an order by. It includes on how to join table with itself by simply setting up a different alias name.