Thanks Naveed,

I got the same result byu doing this

select  B.BranchName,

 count(distinct T.Id) as 'Tran Count',

 count(I.Id) as 'Item Count',

 sum(case when cast(I.iqaresult as int)+ cast(I.iuaresult as int) =0 then 1 else...

Thanx Frank,

Can u tell me how this Referential Integrity is implemented, as Bersileus mentioned?

Thanx Dave for that tip. But is it still possible to do all this in one single query ???

Thanx a bunch Jeff. It works like a dream, i just replaced  your Where condition by

WHERE A.primarykey = BD.primarykey

Shahed

Thanks Frank !!!

An excellent article.