Create a database view

- [Instructor] Sequel select statements … provide a very powerful way … to interact with the data that's stored … in a relational database, … but they can get a little bit long … when you're joining multiple tables together … or have complex filtrating requirements … specified in a where clause. … Luckily relational database management systems … allow you to save a query as something called a view. … This query here at the top of the screen … is the one that we finished the last movie with, … and it pulls the product's name and price … from the products table and matches it … to the supplier name and phone number … from the supplier's table. … These are the results that returned from this query. … Now let's suppose this detailed look … at the product information is something … that you need to access regularly. … Rather than type out the select query every time, … you can save it as a virtual table object in the database. … To do that, place your cursor at the beginning … of line number one, and then press enter …