这个视图该如何建立

[geniusboy]

有三个表
author 主键:authorno
authorno name address
---------- ---------- ----------
01262 谭家华 广州市中山
10286 孙志平 湛江市公园
11539 黄竞文 深圳市华侨

book 主键:authorno,publishno
bookno bookname authorno publishno
---------- ---------- ---------- ----------
02745786 高等数学 01262 012
16786153 微机应用 10286 028
35426845 自然科学 11539 028
57340011 大学英语 11539 115

publish 主键:publish
publishno publishname address
---------- ----------- ----------
012 经济出版社 广州市
028 科学出版社 上海市
115 教育出版社 北京市

其中:author(authorno)与book(authorno),publish(publishno)与book(publishno)具有约束关系.
问:建立视图查看:authorno,name,boookno,bookname,publishname并且按authorno排序

[ropriest]

create view view_name as
select a.authorno,a.name,b.bookno,b.bookname,c.publishname
from author a,book b,plublish c
where a.authorno = b.authorno
and b.publishno = c.publishno
order by a.authorno

[ropriest]

创建视图，可以先在查许分析器中写好你的SQL语句，执行看看结果是否正确，然后在加上创建视图的语句
Create View view_name As
sql
即可

[kimurakenshin]

USE pubs
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_NAME = 'titles_view')
DROP VIEW titles_view
GO
CREATE VIEW titles_view
AS
SELECT a.authorno,a.name,b.bookno,b.bookname,c.publishname
FROM author a inner join book b on a.authorno=b.authorno inner join
publish c on b.publishno=c.publishno
gourp by a.authorno,a.name,b.bookno,b.bookname,c.publishname
GO

[pengdali]

create view 视图 as
select a.authorno,a.name,b.bookno,b.bookname,c.publishname
from author a left join book b on a.authorno = b.authorno
left join plublish c b.publishno = c.publishno
order by a.authorno
go