Database table query? ? ? ? ?

zhutou33

1. There is a table t1 with field names: t1_date, t1_telphone, t1_content
2. There is another table t2 with field names: t2_date, t2_telphone, t2_content
3. Find the total number of tables t1, t1_telphone and t2, t2_telphone of different dates.

Such as:
Date (t1_date) Total number of t1_telphone Total number of t2_telphone

January 1 20 15
January 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 date, (select count(t1_telphone) from t1 where t1_date between @bdate and @edate) as t1_telphone total,
(select count(t2_telphone) from t2 where t2_date between @bdate and @edate) as the total number of t2_telphone
end

select * from #A

/////////////////////
For ms sql server 2000, you can write a stored procedure to try

很累的neo

lz, can the method I wrote for you work? Have you tried it? Why are you doing this? No response after posting. At least you can say something (still not).

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
sorry! I have seen what you did! But I have not tried it yet! I figured out another way! Don't worry, you should also take a look!
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:
For your needs, maybe your method is more suitable. No matter what, the problem is solved.
I may have spoken too much, please don't mind.

贼盗新

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;