create or update a view

http://www.w3schools.com/sql/sql_view.asp

CREATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition