CODE EXAMPLE FOR SQL

syntac for creating view in dbbrowser

CREATE [TEMP | TEMPORARY] VIEW view_name AS
SELECT column1, column2.....
FROM table_name
WHERE [condition];