SQL语句，无法绑定由多个部分组成的标识符
declare@strvarchar(1000)select@str=powerfromtbl_muserwhereuserid="+userId+"select*fro...
declare @str varchar(1000) select @str =
power from tbl_muser where userid = "+userId+" select * from
(select (select name from ao_institution i where y.institution = i.id) institution,
(select name from ao_item t where y.item = t.id) item,num,sqdw,sqr,CONVERT(VARCHAR(24),date,120) date,
CONVERT(VARCHAR(24),overD,111) lastD, id from tbl_ywsl y where y.item in (select str2table from StrToTable(@str)) and y.isbj = ?)a where 1 = 1
javax.servlet.ServletException: javax.servlet.jsp.JspException: 无法绑定由多个部分组成的标识符 "y.institution"。 展开
power from tbl_muser where userid = "+userId+" select * from
(select (select name from ao_institution i where y.institution = i.id) institution,
(select name from ao_item t where y.item = t.id) item,num,sqdw,sqr,CONVERT(VARCHAR(24),date,120) date,
CONVERT(VARCHAR(24),overD,111) lastD, id from tbl_ywsl y where y.item in (select str2table from StrToTable(@str)) and y.isbj = ?)a where 1 = 1
javax.servlet.ServletException: javax.servlet.jsp.JspException: 无法绑定由多个部分组成的标识符 "y.institution"。 展开
1个回答
展开全部
declare @str varchar(1000) select @str = 这里就有问题？
本回答由网友推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
