sql count total calls

Expand Post »

hi guys! i am enim, i usually post thread in PHP and i guess its my first time here in mysql..

i have problem regarding the total count of the terminatecause..
i need the count of ANSWERED calls only and the total count of all calls..
can i do this in one query.. because my query below isn't working..

pls. help

thanx
enim

mysql Syntax (Toggle Plain Text)
SELECT destination, count(terminatecause) as tc							CASE terminatecause 
								WHEN 'ANSWER' THEN count(terminatecause)
								END as allcall
							FROM tblTable1
							JOIN tblTable2on tblTable1.someID = tblTable2.someID
							JOIN tblTable3on tblTable2.someID1 = tblTable3.someID1
							WHERE tblTable3.someID1= '1'
							AND tblTable1.someUser= 'user'
							AND tblTable1.callstarttime BETWEEN '2008-08-01 00:00:00' AND '2008-08-01 23:00:00'
							GROUP BY destination, terminatecause ORDER BY destination asc
select destination, count(terminatecause) as tc							CASE terminatecause 
								when 'ANSWER' then count(terminatecause)
								end as allcall
							from tblTable1
							join tblTable2on tblTable1.someID = tblTable2.someID
							join tblTable3on tblTable2.someID1 = tblTable3.someID1
							where tblTable3.someID1= '1'
							and tblTable1.someUser= 'user'
							and tblTable1.callstarttime between '2008-08-01 00:00:00' and '2008-08-01 23:00:00'
							group by destination, terminatecause order by destination asc

Last edited by peter_budo; Nov 20th, 2008 at 8:23 am. Reason: corecting code, no spaces inside the tag

Similar Threads

I lack focus... in Java

enim213

Reputation Points: 11

Solved Threads: 2

Light Poster

Offline

40 posts
since Jun 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Counting MySQL connections on a page

Next Thread in MySQL Forum Timeline: Inserting new row in mysql

DaniWeb Message

Cancel Changes

User Name
Password