28,406
社区成员
发帖
与我相关
我的任务
分享可以将两个查询结果再合成一个表吗?
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
可以将这两条查询语句再合成一个新表吗?
...全文
请发表友善的回复…
发表回复
