• calabast@lemm.ee
    link
    fedilink
    arrow-up
    19
    ·
    edit-2
    11 months 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”