replace temp table with join

[premtemp]

Hello,
I have a table that I querying using the query below. This is very large table (1000000 record) . The query works but I don;t want to use the temp table. Any suggession will be helpful

Thanks


insert into temp select Cid from CallTimes where EndTime < '2008-06-01';
Select Cid ,count(*) as n from Temp group by CallID having n > 1;