+ 1
Why do we need to use view?
2 Answers
+ 2
we use views because of simplicity suppose we have a select statement to join several tables and take many unions ,it would not be sensible to write whole code in single statement ,it will be harder to understand while if we use veiw every step would be clear and better understandable
+ 1
create view is the best approach for extracting reports.