6.26. SQL Views

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