注册 登录
编程论坛 ASP.NET技术论坛

操作符丢失 SQL语句

qkhhwfnh861 发布于 2009-08-15 22:33, 581 次点击
string cmdText = " select [MessageForSingle].*,S.Username as SenderName,R.Username as ReceiverName from [MessageForSingle] inner join [User] S on S.ID=MessageForSingle.Sender inner join [User] as R on R.ID=MessageForSingle.Receiver"               
  +" WHERE (MessageForSingle.Sender=@UserID AND MessageForSingle.Receiver=@UserID) OR (MessageForSingle.Sender=@FellowID AND MessageForSingle.Receiver=@UserID) ORDER BY CreateDate DESC";

结果提示操作符丢失    S.ID=MessageForSingle.Sender inner join [User] as R on R.ID=MessageForSingle.Receiver

什么问题
1 回复
#2
panyanyan2009-08-21 12:53
跟个断点 看下  cmdText   的 sql 语句到底是什么   然后 在SQL中执行下 SQ 语句     看有没错误
1