sqlite创建视图的问题

ziffer

sqlite> create view addressbook.testview as
   ...> select  ifnull(First,"")||ifnull(Middle,"")||ifnull(Last,""),value from addressbook.ABPerson,addressbook.ABMultiValue   ...> where ABPerson.ROWID = ABMultiValue.record_id;

视图结构就成了下面这个样子：
ifnull(First,"")||ifnull(Middle,"")||ifnull(Last,"")|value

共两列，第一列叫ifnull(First,"")||ifnull(Middle,"")||ifnull(Last,"")  
第二列叫value
我想把第一列改成names，可是create view addressbook.testview(names,address) as
或create view addressbook.testview(names char(20),address char(40)) as
报语法错，请问又什么办法创建视图时重命名这列？
谢啦

ziffer

没有人知道吗？