CREATE VIEW order_view AS SELECT o.id, c.name, o.orderdate, o.quantity FROM orders o, catalog c where o.catalogid = c.id order by id desc; ...