you are viewing a single comment's thread
view the rest of the comments
[–] 19 points 2 years ago* (last edited 2 years ago)

A view is a saved query that pretends it's a table. It doesn't actually store any data. So if you need to query 10 different tables, joining them together and filtering the results specific ways, a view would just be that saved query, so instead of "SELECT * FROM (a big mess of tables)" you can do "SELECT * FROM HandyView"

  • source
  • parent