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