about self join

[sql]

when we use self join, if I have table contain some Feetype, status( normal, Split, Unsuccessful) how can I get the count(success),success=normal, Split
and the count( Unsuccessful) at some time
________
Amc Computerized Engine Control

[skhanal]

You don't need self join for that, you can use GROUP BY

select status, count(*)
from table
group by status

[sql]

thank you ,
I need to group by FeeType;
Year one or not year one
successful or Unsuccessful , on meantime , i have select
select FeeType,processStatus, Count(*) from PostStatus, Records, student
where PostStatus.UserId=Records.UserId
and PostStatus.UserId=student.UserId
and Year<>'1'
group by FeetYpe,processStatus
________
Ls