create procedure GetFriends
(
@userid int
)
as
select Trend,TrendDate,MyMood from MymyUsers where UserId in
(
select FbId from MymyFriends where FaId=@userid and (State=1 or State=2)
select FaId from MymyFriends where FbId=@userid and State=2
)以上是我写的存储过程,是不正确的写法啊。但它说明了我的问题,就是如何结合“select FbId”,“select FaId”这两个独立的语句来符合UserId in的要求?从来都没碰到过这样的问题,不知道怎么解决啊!急死人了!
解决方案 »
- 在超过10万条记录的页面显示时,你如何处理分页,有多少种替代方案?
- Framwork 3.5的website型项目,如果能让global.asax.cs和global.asax在一起,和aspx页面一样,而不是在appcode中
- UUB编辑器
- 急求有经验的达人帮忙解答疑惑!!!!
- InfoPaht 启动代码编程时,报无法启动VSTA
- 100分在线等一个<marquee>和flash之间冲突的问题,解决立刻给分
- 在列表框中显示树型数据出问题!!!不显示数据,能解决者送100分
- 弹出窗口被覆盖?????
- 我怎么搞不懂ASP.net等网页数据库编程什么入门?原来我只会VB的编程。参与给分
- 高分请问高手!!! 如何使用服务器Button控件来弹出一个新窗口,并且传参数进去!!!
- 网站设计
- window service 安装(立即给分)
这样可以吗
create procedure GetFriends
(
@userid int
)
as
select Trend,TrendDate,MyMood from MymyUsers where UserId in
(
select FbId from MymyFriends where FaId=@userid and (State=1 or State=2)
)
or
UserId in
(
select FaId from MymyFriends where FbId=@userid and State=2)
(
@userid int
)
as
select Trend,TrendDate,MyMood from MymyUsers where UserId in
(
select FbId from MymyFriends where FaId=@userid and (State=1 or State=2)
)
or
UserId in
(
select FaId from MymyFriends where FbId=@userid and State=2)
我还没有写完呢,你就出来了
(
@userid int
)
as
select Trend,TrendDate,MyMood from MymyUsers where UserId in
(
select FbId from MymyFriends where FaId=@userid and (State=1 or State=2)
)
or
UserId in
(
select FaId from MymyFriends where FbId=@userid and State=2)
(
@userid int
)
as
select Trend,TrendDate,MyMood from MymyUsers where UserId in
(
select FbId from MymyFriends where FaId=@userid and (State=1 or State=2)
union
select FaId from MymyFriends where FbId=@userid and State=2
)