Was this helpful?
DEFINE VIEW Example
The following example defines a view of employee data that includes name, salary and manager's name:
## range of e is employee
## range of d is dept
## define view empdpt 
##  (ename = e.name, e.sal, dname = d.name)
##  where e.mgr = d.mgr
Last modified date: 01/30/2023