select zjid,num=count(*) from (select * from A UNION ALL select * from B) m group by zjid having count(*)>3
select c.zjid from (select zjid from A union all select zjid from B) c group by c.zjid having count(c.*)>3
select a.zjid from a join b on a.zjid=b.zjid group by a.zjid having count(a.zjid)>2
不好意思 是快了点 select zjid from (select * from A UNION ALL select * from B) m group by zjid having count(*)>3
select a.zjid from a join b on a.zjid=b.zjid group by a.zjid having count(a.zjid)>2
我刚才又仔细看了一下你的问题,你的意思是表A和表B 两个表所有出现的这个字段相同值的次数超过三次的zjid那应该这样做: select zjid from (select zjid from A UNION ALL select zjid from B) c group by zjid having count(*)>3
更正一下:我刚才又仔细看了一下你的问题,你的意思是表A和表B 两个表所有出现的这个字段相同值的次数超过三次的zjid那应该这样做: select zjid from (select zjid from A UNION ALL select zjid from B) c group by zjid having count(*)>3
select zjid from (select zjid from A UNION ALL select zjid from B) c group by zjid having count(*)>3 对啊,surn(半岁毛孩.sql) 的 select * from A,B where zjid count(*)>3 相当于 select zjid from (select zjid from A UNION select zjid from B) c group by zjid having count(*)>3 会在组合A,B表记录时,把两表中相同记录合并为1条
等我回贴时,你已经成为楼上了。我刚才说的楼上是指,xiaomeixiang。
surn(半岁毛孩.sql)的方法肯定是错误的。
from
(select * from A
UNION ALL
select * from B) m
group by zjid having count(*)>3
c.zjid
from
(select zjid from A union all select zjid from B) c
group by
c.zjid
having count(c.*)>3
select zjid
from
(select * from A
UNION ALL
select * from B) m
group by zjid having count(*)>3
两个表所有出现的这个字段相同值的次数超过三次的zjid那应该这样做:
select zjid from (select zjid from A
UNION ALL select zjid from B) c
group by zjid having count(*)>3
两个表所有出现的这个字段相同值的次数超过三次的zjid那应该这样做:
select zjid from (select zjid from A
UNION ALL select zjid from B) c
group by zjid having count(*)>3
UNION ALL select zjid from B) c
group by zjid having count(*)>3
对啊,surn(半岁毛孩.sql) 的
select * from A,B where zjid count(*)>3
相当于
select zjid from (select zjid from A
UNION select zjid from B) c
group by zjid having count(*)>3
会在组合A,B表记录时,把两表中相同记录合并为1条