关于视图——一段语句好多错误,求解释
CREATE VIEW dbo.fuwuyuanhecaidan
AS
SELECT TOP 10 PERCENT dbo.fuwuyuan_cxc.username_cxc, dbo.diancaidan_cxc.caidanhao_cxc,
dbo.guke_cxc.username_cxc AS gukename
FROM dbo.diancaidan_cxc INNER JOIN
dbo.fuwuyuan_cxc ON
dbo.diancaidan_cxc.fuwuyuanbianhao_cxc = dbo.fuwuyuan_cxc.fuwuyuanbianhao_cxc INNER JOIN
dbo.guke_cxc ON dbo.diancaidan_cxc.caidanhao_cxc = dbo.guke_cxc.caidanhao_cxc
ORDER BY dbo.fuwuyuan_cxc.username_cxc
为什么好多错误? 求解释
AS
SELECT TOP 10 PERCENT dbo.fuwuyuan_cxc.username_cxc, dbo.diancaidan_cxc.caidanhao_cxc,
dbo.guke_cxc.username_cxc AS gukename
FROM dbo.diancaidan_cxc INNER JOIN
dbo.fuwuyuan_cxc ON
dbo.diancaidan_cxc.fuwuyuanbianhao_cxc = dbo.fuwuyuan_cxc.fuwuyuanbianhao_cxc INNER JOIN
dbo.guke_cxc ON dbo.diancaidan_cxc.caidanhao_cxc = dbo.guke_cxc.caidanhao_cxc
ORDER BY dbo.fuwuyuan_cxc.username_cxc
为什么好多错误? 求解释
作者: guiji6606 发布时间: 2011-12-27
啥错误啊
吧错误发上来。
吧错误发上来。
作者: oswica 发布时间: 2011-12-27