如何编写多源表视图

[weixin_41581703]

table1 client(cno,cname,trades caddress)
table2 product(pno, pname,..)
table3 pro(pno, cno,amount，date)

请问怎样编写视图
create view IS_view(cname,trades,pname,amount)

[OwenZeng_DBA]

把3个表join起来就可以

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('client') IS NOT NULL DROP TABLE client
IF OBJECT_ID('product') IS NOT NULL DROP TABLE product
IF OBJECT_ID('pro') IS NOT NULL DROP TABLE pro
IF OBJECT_ID('IS_view') IS NOT NULL DROP VIEW IS_view
GO
CREATE TABLE client(cno NVARCHAR(20),cname NVARCHAR(20),trades NVARCHAR(20),caddress NVARCHAR(20))
CREATE TABLE product(pno NVARCHAR(20), pname NVARCHAR(20))
CREATE TABLE pro(pno NVARCHAR(20), cno NVARCHAR(20),amount NVARCHAR(20),[date] DATETIME)
GO
create view IS_view
AS
SELECT 
	a.cname
	,a.trades
	,c.pname
	,b.amount
FROM client A INNER JOIN pro AS B ON a.cno=b.cno
	INNER JOIN product AS C ON b.pno=c.pno
GO
SELECT * FROM is_view

这样？

[听雨停了]

我来排个队

[二月十六]