difference and the point if View?

Question

Why have view , when uou just do a seleft command lets say for a inner join what it returns isnt that the same as a view

Answer 1

Take a look at these:

[Why]
https://stackoverflow.com/questions/1278521/why-do-you-create-a-view-in-a-database

[When]
https://stackoverflow.com/questions/4378068/when-to-use-a-view-instead-of-a-table

Hth, cmiiw