6.20. SQL Views

CREATE VIEW myview AS
SELECT `firstname`, `lastname`
FROM users