Select * from soccer_player where posit='前锋' and player_id=(select player_id from soccer_exchange where user_id=user_id and state=1)
sql语句错了,要不你改成
Select * from soccer_player where posit='前锋' and player_id=(select top 1 player_id from soccer_exchange where user_id=user_id and state=1)
sql语句错了,要不你改成
Select * from soccer_player where posit='前锋' and player_id=(select top 1 player_id from soccer_exchange where user_id=user_id and state=1)
解决方案 »
- 数据库语句 求助帖
- 关于GridView邦定XmlDataSource问题
- 100分求助!如何把图片变形
- ====母页面如何向弹出的新页面传递参数====
- ****高分求解**** 关于开发2005开发环境的问题 ****顶帖有分***
- dataset转xml,在dataset里面包含图片字段;当我把xml再转回dataset时图片就御览不了。那里的问题?
- 如何嵌套部分网页
- 如何实现多行文本在数据库中的输入输出呀?(菜鸟SOS)
- 关于数组的问题(大家帮我运行下)
- Get方式如果获取类似webbrowser中innerhtml数据
- C#怎么没有时间戳的函数,奇怪呢?
- 急.....................高手指教!!!
得到的可能不是一个值呀!
如果贞德要得到多个,可以这样写:
Select * from soccer_player where posit='前锋' and exists (select player_id from soccer_exchange where user_id=user_id and state=1
Select * from soccer_player where posit='前锋' and player_id=any (select player_id from soccer_exchange where user_id=user_id and state=1)