Views

create

-- Single table view
--
create view nh_cust as
    select name, phone
    from customer
    where state = 'NH';

-- Multi-table view
--
create view sales as
    select customer.name, order.total
    from customer join order
    using (customer_id);

update

• Many database engines don't allow updates to views