therefore instead of creating a table with those
wanted fields or writing complex queries,we may
create a view table taking the fields from
those tables which includes the fields of interest
within a very short time.It has many advantages.
following steps shows how to create a view -

1.open or expand the database folder in sql server

2.then right click on the view folder and click
new view.

3.from the add table dialog box select the tables
from which the fields needed and click add.after
that click close button.

4.u will see the table fields.select which fields
u need to create view table.then click save button
in sql server.

5.give a name of the view table.

6.done.you created a view table.use it as a table
with your required fields.