Hello all.

I really have problem understanding SQL VIEWS, i keep reading this view explanations articles but i'm can't REALLY understand when and why to use them. this is what i understand so far

A) VIEW is virtual table to instead storing data it stores the query of one or more table
- OK, no problem.

B) VIEWS only display to the end user columns or rows we would like him/she to see.

- but I do it with regular query by selecting only the desire columns / rows
where is the different ?

can someone please explain it very slow and simple ??

Thanks!