Link to home
Create AccountLog in
Avatar of Tagom
Tagom

asked on

return select data

I have the following query which allows me to produce a table within iReport
I only want to print certain fields - iReport is not letting me distinguish which fields.
I can do this in sqlServer - not sure how - probably a case or select within select -
if query returns counts of application 1, application 2, application 3 -but I only want to see results of application 2 how would I do so -
SELECT  Count(CLE_TYPE) AS [CallCount],CLT_DESC AS [EventType], CLX_DESC AS [Application], UTILITY_NAME as [Utility]
		FROM CL_EVENTS_IDX WITH (NOLOCK) 
		INNER JOIN CL_EVENTS WITH (NOLOCK) ON CLE_ID = CLE_IDX_KEY
		INNER JOIN UTILITY_INFO WITH (NOLOCK) ON CLE_IDX_UCODE = UTILITY_KEY
		INNER JOIN CL_APPID_XREF WITH (NOLOCK) ON CLE_EVID = CLX_APPID
		INNER JOIN CL_TYPES WITH (NOLOCK) ON CLE_TYPE = CLT_ID    		
		GROUP BY UTILITY_NAME, CLX_DESC, CLT_DESC

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of ralmada
ralmada
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Tagom
Tagom

ASKER

second one! Testing now - thank you!
Avatar of Tagom

ASKER

how would I add two columns in the query above
ie
sum(application 1, application 2) AS total transfered