I would like to create a VIEW from three tables and i would like to sort 
the
output by on of the fields. i am able to create the view but i dont know 
how
to do the sorting of the data (for example, how do i specify that i want to
sort the output by AuthorID). And also is there any way we can print the
output of the view??