数据库表的查询？？？？？

zhutou33

1.有一个表t1有字段名：t1_date,t1_telphone,t1_content
2.有另一个表t2有字段名：t2_date,t2_telphone,t2_content
3.求不同日期表t1,t1_telphone的总数，表t2,t2_telphone的总数。

如：
日期（t1_date）     t1_telphone的总数         t2_telphone的总数

1月1号                  20                         15
1月2号                  14                         17

阿格拉玛露露

select count(t1_telphone) from t1

seakey

select count(t1_telphone) from t1,t2 where t1.t1_date=t2.t2_date

很累的neo

DECLARE  @bdate datetime;
declare @edate datetime
set @bdate='2016-12-01'
set @edate='2016-12-31'
if exists(
select * from tempdb.dbo.[sysobjects] where name like'#A%')
drop table #A
select getdate() as d into #A
delete #A

while @bdate<@edate
begin
set @bdate=dateadd(d,1,@bdate)
insert #A
select(@bdate) as 日期,(select count(t1_telphone) from t1 where t1_date between @bdate and @edate) as t1_telphone的总数,
(select count(t2_telphone) from t2 where t2_date between @bdate and @edate) as t2_telphone的总数
end

select * from #A

/////////////////////
针对ms sql server 2000的，你自己可以写一个存储过程试试

很累的neo

lz，我给你写的那个方法行不行啊？你试了没有？你怎么这样？发了帖子就没有回应了。最起码你说一句可以了（还是不行）啊。

spaniel

select t1.t1_date as mydate, sum(t1.t1_telephone) as t1phone, sum(t2.t2_telephone) as t2phone
from t1, t2
where t1.t1_date = t2.t2_date
group by t1.t1_date;

zhutou33

很累的neo
不好意思哦！我已经看了你做的了！但得不得我还没有试过！我想出了另一种方法了！不防你也看一下咯！
select SENDDATE,sum(T1),sum(T2) from
(select t1_date SENDDATE ,count(*) T1,0 T2 from t1 group by t1_date)union
(select t2_date ,0,count(*) from t2 group by t2_date))group by SENDDATE ;

udddgv

SELECT t1.t1_date AS mydate, sum(t1.t1_telephone) AS t1phone, sum(t2.t2_telephone) AS t2phone
FROM t1, t2
WHERE t1.t1_date = t2.t2_date
GROUP BY t1.t1_date;

很累的neo

lz:
针对你的需求，也许你的方法更合适。不管怎么的，问题解决就好。
我说话也许过分了一些，请不要介意。

贼盗新

select t1.t1_date as thdDate, count(t1.t1_telephone) as t1phone, count(t2.t2_telephone) as t2phone
from t1, t2
where t1.t1_date = t2.t2_date
group by t1.t1_date;