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