Views in SQL
What is a View? A view is nothing more than a saved SQL query . A view can also be considered as a virtual table . View script Create view VIEW_NAME AS SELECT T1. CUSTEMOR _NAME , T1.CUST_ID , T1.Address, T2.Order_units From CUSTERMORTABLE AS T1 Inner join ORDERS AS T2 ON T1.CUST_ID =T2.CUST_ID Where order_units > = 60