CREATE VIEW [vb_GoodsInfo]
AS
SELECT [dbo].[tb_GoodsInfo].[GoodsID], [dbo].[tb_GoodsInfo].[GoodsName], [dbo].[tb_GoodsInfo]. [GoodsIntroduce], [dbo].[tb_GoodsInfo].[GoodsPrice], [dbo].[tb_GoodsInfo].[GoodsPhoto], [dbo].[tb_GoodsInfo].[GoodsIsNew], [dbo].[tb_GoodsInfo].[GoodsDate], [dbo].[tb_GoodsType].[GoodsTypeName], [dbo].[tb_GoodsType].[StoreID], [dbo].[tb_StoreInfo].[StoreName]
FROM [dbo].[tb_GoodsInfo], [dbo].[tb_GoodsType], [dbo].[tb_StoreInfo]
为什么不出现INNER JOIN……ON语句,是自动生成还是输入。就是成为这个样子
CREATE VIEW dbo.vb_GoodsInfo
AS
SELECT dbo.tb_GoodsInfo.GoodsID, dbo.tb_GoodsType.GoodsTypeID,
dbo.tb_GoodsType.GoodsTypeName, dbo.tb_StoreInfo.StoreName,
dbo.tb_GoodsInfo.GoodsName, dbo.tb_GoodsInfo.GoodsIntroduce,
dbo.tb_GoodsInfo.GoodsPrice, dbo.tb_GoodsInfo.GoodsPhoto,
dbo.tb_GoodsInfo.GoodsIsNew, dbo.tb_GoodsInfo.GoodsDate
FROM dbo.tb_GoodsInfo INNER JOIN
dbo.tb_GoodsType ON
dbo.tb_GoodsInfo.GoodsTypeID = dbo.tb_GoodsType.GoodsTypeID INNER JOIN
dbo.tb_StoreInfo ON dbo.tb_GoodsType.StoreID = dbo.tb_StoreInfo.StoreID
AS
SELECT [dbo].[tb_GoodsInfo].[GoodsID], [dbo].[tb_GoodsInfo].[GoodsName], [dbo].[tb_GoodsInfo]. [GoodsIntroduce], [dbo].[tb_GoodsInfo].[GoodsPrice], [dbo].[tb_GoodsInfo].[GoodsPhoto], [dbo].[tb_GoodsInfo].[GoodsIsNew], [dbo].[tb_GoodsInfo].[GoodsDate], [dbo].[tb_GoodsType].[GoodsTypeName], [dbo].[tb_GoodsType].[StoreID], [dbo].[tb_StoreInfo].[StoreName]
FROM [dbo].[tb_GoodsInfo], [dbo].[tb_GoodsType], [dbo].[tb_StoreInfo]
为什么不出现INNER JOIN……ON语句,是自动生成还是输入。就是成为这个样子
CREATE VIEW dbo.vb_GoodsInfo
AS
SELECT dbo.tb_GoodsInfo.GoodsID, dbo.tb_GoodsType.GoodsTypeID,
dbo.tb_GoodsType.GoodsTypeName, dbo.tb_StoreInfo.StoreName,
dbo.tb_GoodsInfo.GoodsName, dbo.tb_GoodsInfo.GoodsIntroduce,
dbo.tb_GoodsInfo.GoodsPrice, dbo.tb_GoodsInfo.GoodsPhoto,
dbo.tb_GoodsInfo.GoodsIsNew, dbo.tb_GoodsInfo.GoodsDate
FROM dbo.tb_GoodsInfo INNER JOIN
dbo.tb_GoodsType ON
dbo.tb_GoodsInfo.GoodsTypeID = dbo.tb_GoodsType.GoodsTypeID INNER JOIN
dbo.tb_StoreInfo ON dbo.tb_GoodsType.StoreID = dbo.tb_StoreInfo.StoreID
解决方案 »
- 新手请教问一个存储过程的写法,谢谢!
- 一条语句中,同一个子查询,出现多次对效有何影响?
- 超级菜鸟问题!希望高手们不要嫌我菜,给说下。
- 如何向存储过程中传参数?
- Transact-SQL 函数的一个问题
- 数据类型float与real的区别
- 高手来啊,SQL的字符串分截后变成多行数据。(急)
- sql到oracle转化的问题...
- SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating thi
- SQL 2000在WINDOWS SERVER 2003上不能正常运行!!!!!
- 求SQL语句
- 求 sql 从某一字符开始的类似隔行查询
select 总行数=count(1) from 视图
就可以看出区别啦。