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

update view

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