Hi,

this is the exact statement which we are using.

SELECT pb.TransactID FROM Master_data pb INNER JOIN Transact ch on pb.PolicyNo = ch.PolicyNo and

pb.InstructionId = ch.ContHstid

WHERE...

Lynn Pettis,

Thanks for your reply...

again a strange thing!! that is i am able to retrive the results for top 7 records. where as

if i queried 'Select top 8 ...