Thanks for your valuable time,Based upon your suggestion i have just modified my query as follows

For SEM.IsStockIn=1

Select SEC.EntryQty

from child SEC

inner join master SEM on SEC.CBranchID=SEM.BranchID and SEC.centrynumber=SEM.EntryNumber

where SEM.MasterID=1 and...

Because it belongs to isstockin = 0 for your reference I have one more column in @child table named as childMasterID where associated masterid in master tables...

roger.price-1150775 (3/23/2015)

---

It would be useful if you could post the table schema and script to populate it with your test data. Reading your code the results look to be correct....