As I can understand, you should not use INTO in SELECT statement. When view created, you can execute it by issuing "USE view1" command.

>Thanks all for the answers I'm getting from you guys. You guys are great. Here is another one ........ Can you use a SELECT statement with [INTO] for a view like they are used for in a table?
>Something like
>
>SELECT view1
>
>INTO view2
>
>OR
>
>SELECT table1
>
>INTO view1.