It selects the rows from the two tables that have equal value in all matched columns. If the columns have the same name but different data types then natural join will give an error. It is not possible to do a join without explicitly specifying the column in the corresponding tables. It is possible to let the join be completed automatically based on columns in the two tables which have matching data types and names using the natural join keyword.
In the above example dept table is joined to the emp table by the dept-id column which is the only column of the same name and data type in both the tables. The above example can also be written as an equijoin.
in a natural join it is also possible to add a where clause.
A view is a virtual table in the database defined by a query. A view does not exist in the database as a stored set of data values. The rows and columns of data visible through the view are produced by the query that defines the view.
Horizontal view restricts a user's access to selected rows of a table.
Vertical view restricts a user's access to select columns of a table.