28,404
社区成员
发帖
与我相关
我的任务
分享可以将两个查询结果再合成一个表吗?
select up_user_name,up_user_jb,sum(totalpay)as 总积分,sum(totalpoint) as 总稿酬,count(cont_id) as 发表文章数 from cont
where up_date>= #2005-11-25# and up_date <= #2005-12-26# Group by up_user_name , up_user_jb
select up_user_name ,count(cont_id) from cont where up_date>= '2005-11-25' and up_date <= '2005-12-26' and totalpoint is
not null Group by up_user_name
可以将这两条查询语句再合成一个新表吗?
where up_date>= #2005-11-25# and up_date <= #2005-12-26# Group by up_user_name , up_user_jb
select up_user_name ,count(cont_id) from cont where up_date>= '2005-11-25' and up_date <= '2005-12-26' and totalpoint is
not null Group by up_user_name
可以将这两条查询语句再合成一个新表吗?
...全文
请发表友善的回复…
发表回复
soloist007 2005-12-28
- 打赏
- 举报
select
需要的东东
from
(select ... from ... where ... ) A,
(select ... from ... where ... ) B
where
A.XXX = B.XXX
需要的东东
from
(select ... from ... where ... ) A,
(select ... from ... where ... ) B
where
A.XXX = B.XXX
笨笨兔兔兔兔兔 2005-12-27
- 打赏
- 举报
just a joke
我没看你写的,随手了一下,要是有误解的话,误怪
我没看你写的,随手了一下,要是有误解的话,误怪
笨笨兔兔兔兔兔 2005-12-27
- 打赏
- 举报
union all
asdfasdfdfas 2005-12-27
- 打赏
- 举报
那这个条件怎样写,up_user_name是一样的,但两条都是查询的结果,该怎样连接这两条查询结果呢?
银狐被占用 2005-12-27
- 打赏
- 举报
用条件关联，都可以实现。
