oracle :create table tablename as select * from viewnamesqlserver:select * into tablename from viewname
ps:
create view viewName AS select * from table (创建视图)
create view TaskRecordView as
SELECT TaskId as taskId ,p2.UserId as buyerId,OrderNo as orderNo,backCase as bankCase,RefusedReason as refusedReason,p2.CreatedDate as createDate,Status as status,StoreName as storeName,ProductName as productName,ProductURL as productURL,ProductImage as ProductImage,TaskType as taskType,TaskNum as taskNum ,u.Name as name ,u.UserName as userName,WxAccount as wxAccount FROM
(SELECT * from TaskProgressDetails as p where state=1) as p2
INNER JOIN TaskBaseInfo as b ON p2.TaskId=b.Id
INNER JOIN [User] as u ON u.id=p2.UserId;
(内联查询)
http://zhidao.baidu.com/link?url=uZSNnsza82gFxpPT6uJhTb85zI96lIRQiQrCnBygSmJAY_AMwpJUSUnPjjB26hW569Ppz7Ce8ujNZiPMNiH5za