View vs simple select querry
how is a view different from a simple select querry. after all it's the same as the result produced by a select querry with/without a join. also I think that a view requires more lines of queries. now can we use the join anytime or does it last only for a session? I guess that's the only use of it to select a view again and again once created. what is the lifetime of a view?