在SQL Server 2005中创建视图 [英] create views in sql server 2005

问题描述

你好

我在SQL Server 2005中用以下两个表创建视图:

表A:三列ID [数字]，日期[日期时间]，名称ID [varchar]

表B:两列ID [数字]，名称[varchar]

查看以下SQL查询:

hello

i create a view in sql server 2005 with two following tables :

table A : three columns id [numeric],date [datetime],nameID [varchar]

table B : two column id [numric], name [varchar]

view sql query following :

CREATE VIEW [dbo].[AB]
AS
SELECT A.id,(select name from B where b.id in (a.nameID)) as names from A
GO

但是发生了一些错误.如何解决这个问题?

请帮助

but occurred some error . How to solve this problem ?

please help

推荐答案

可能是您从B返回了多个名称

试试:

Chances are you are returning more than one name from B

Try:

SELECT A.id, B.name as names
FROM A 
INNER JOIN B ON A.nameID = B.id

这篇关于在SQL Server 2005中创建视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！