FIT
100
More Complex Queries and SQL Functions
v
Virtual Tables: Creating a View
o
CREATE VIEW <view name> AS
SELECT … FROM … WHERE …;
o
Example:
;
CREATE VIEW PRODUCT_3 AS
SELECT P_DESCRIPT, P_ONHAND, P_PRICE
FROM PRODUCT
WHERE P_PRICE > 50.00;