永利体育登陆_官方在线

错误信息:
错误[Microsoft][ODBC SQL Server Driver][SQL Server]子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后,或子查询用作表达式时,这种情况是不允许的。 sql: select top 3 CustomerMsgID, isnull(Member.NickName,loginName), CustomerMsg.DateCreated, Msg, Reply from CustomerMsg left outer join Member on CustomerMsg.MemberID = Member.MemberID where MsgType in (1,3) and ispassed = 1 and IsPublic = 1 and (select convert(int,ProductID)%9 from Product where productcode='B0007')=convert(numeric(18),substring(convert(varchar(20),CustomerMsg.DateCreated,120),19,1) ) order by CustomerMsg.datecreated desc
错误代码:
1000
永利体育登陆