执行:
select a.wid, a.hit+b.hit+c.hit hits from tb_bajieword a join tb_bajieword b join tb_bajieword c on a.wid=b.wid and a.wid=c.wid where a.word='开放' and b.word='图片' and c.word='因为' order by hits desc;
得到21个结果
但执行:
select a.wid, a.hit+b.hit+c.hit+d.hit hits from tb_bajieword a join tb_bajieword b join tb_bajieword c join tb_bajieword d on a.wid=c.wid and a.wid=d.wid where a.word='开放' and b.word='图片' and c.word='因为' and d.word='站长' order by hits desc;
却得到了6069个结果肯定是什么地方出问题,请大侠赐教。
select a.wid, a.hit+b.hit+c.hit hits from tb_bajieword a join tb_bajieword b join tb_bajieword c on a.wid=b.wid and a.wid=c.wid where a.word='开放' and b.word='图片' and c.word='因为' order by hits desc;
得到21个结果
但执行:
select a.wid, a.hit+b.hit+c.hit+d.hit hits from tb_bajieword a join tb_bajieword b join tb_bajieword c join tb_bajieword d on a.wid=c.wid and a.wid=d.wid where a.word='开放' and b.word='图片' and c.word='因为' and d.word='站长' order by hits desc;
却得到了6069个结果肯定是什么地方出问题,请大侠赐教。
解决方案 »
- 求助MySql Connector Net 6.5.4安装包!!!
- 这句select TIMEDIFF() 能否简化
- mysql查询问题,总是报错,个人认为语句无错
- 这种功能如何设计合理的数据表?
- mysql 有没有类似sqlserver 的 tl-sql 功能
- id in 和 id=n or id=n2.....!哪个效率高?
- MySql 数据库存储过程若干问题:
- 从jsp页面中往mysql里面加数据,tomcat报错:SQLException: Invalid authorization specification: Access denied for user: 'root
- 导入sql文件时,提示[Err] 1146 - Table 'jieyuenew.cmjobcode' doesn't exist
- 发个求助帖子关于mysql中文显示的
- 怎样按一定时间内对数据进行去重
- 请问php如何调用oracle数据
from tb_bajieword a join tb_bajieword b join tb_bajieword c on a.wid=b.wid and a.wid=c.wid
where a.word='开放' and b.word='图片' and c.word='因为' order by hits desc;
select a.wid, a.hit+b.hit+c.hit+d.hit hits
from tb_bajieword a join tb_bajieword b join tb_bajieword c join tb_bajieword d on a.wid=c.wid and a.wid=d.wid
where a.word='开放' and b.word='图片' and c.word='因为' and d.word='站长' order by hits desc;
你多JOIN了一个表,并且没有任何限制。