Hi, I would like to know about subquery,and view ,what is the actual necessary to create those things in mysql. Please give me some example which are easy to understand. Thanks