select * from user,exp where user.username=exp.username
解决方案 »
- treeview 添加节点问题
- Server cannot modify cookies after HTTP headers have been sent
- 后台程序怎么获取层的样式
- 请教一个简单的问题
- 请教 页面刷新问题
- 如何将一个byte图象放在datagrid控件里?
- .net 里用UrlRewriter 实现伪静态的问题请教.
- 开发好维护的asp.net 后台,需要分层吗?需要用什么框架或技术吗?
- 求当验证窗体不满足条件时,要求弹出个一个对话框提示的代码.
- 紧急!为何翻页后,查询就会出问题????
- Page.RegisterStartupScript 和response.write 的区别
- 在文本筐中输入html代码,提交后为什么老是报错阿?如何解决,急,谢谢!!
FROM [user] AS a, exp AS b ,exp as c
WHERE (a.experience)>[b].[exp] and a.experience<c.exp
GROUP BY a.username,a.pwd
select a.* ,(select [level] from exp where exp in (select max(exp) from exp where exp <(select exprience from user where username='yourname'))) as 本等级,
(select [level] from exp where exp in (select min(exp) from exp where exp >(select exprience from user username='yourname'))) as 下一等级 from user a where a.username='yourname'得到 用户名+密码+经验+本等级+下一等级
SELECT a.username,a.pwd, Max(b.exp) AS exp1 ,min(c.exp) as exp2
FROM [user] AS a, exp AS b ,exp as c
WHERE (a.experience)>[b].[exp] and a.experience<c.exp
与
...
where [b].[exp]<a.exp and c.exp>a.exp
有什么区别,是否可以说是从exp表中取出符合条件的名字与user表合成对吗?