Can anyone help with merge sql statement.

[ssmeshack]

Hi there,

Im trying to do a table view with each of the statement will give output in each column. but i dono how to combine this two statement to become one sql statement. Please help me.

RESOLVED
select Ticowner, count(TicStatus)as "resolved"
From Ticket
where Ticstatus = 'resolved'
Group by Ticowner
 
 
UNRESOLVED
select Ticowner, count(TicStatus)as "UNresolved"
From Ticket
where Ticstatus <> 'resolved'
Group by Ticowner

Regards,
Meshack

[r035198x]

Will UNION help?

[ssmeshack]

hi r035198x,

Will UNION help?

thanks for reply...
union can merge but not as i want....
if i use union, it will look like this...

select Ticowner, count(TicStatus)as "resolved"
From Ticket
where Ticstatus = 'resolved'
Group by Ticowner
Union
select Ticowner, count(TicStatus)as "UNresolved"
From Ticket
where Ticstatus <> 'resolved'
Group by Ticowner

Ticowner | resolved
LB | 2
LB | 3
MEA | 1
MEA | 3
RAS | 2
RAS | 7

i want something looksn like this....

Ticowner | resolved | unresolved
LB | 2 | 3
MEA | 3 | 1
RAS | 7 | 2

Can help me ah? I have no idea how to do it.... Im just know the basic only....
thanks again.

- Meshack

[r035198x]

Try something like

select T.Ticowner,
(select count(tt.TicStatus)as "resolved"
From Ticket tt
where tt.Ticstatus = 'resolved'
and tt.Ticowner = T.Ticowner) as resolved,
 
(select count(tt.TicStatus)as "unresolved"
From Ticket tt
where tt.Ticstatus <> 'resolved'
and tt.Ticowner = T.Ticowner) as unresolved
 
from Tickect T

I haven't tested it though.

[ssmeshack]

Hai r035198x,

Its working well... thank you very much...

-Meshack