Dear, got that you need to retrieve data from these tables, but what is the issue?

[font="Courier New"]I think U R using a view to query ur results.

while creating a view use nolock in ur create view statement, and then try it. for ex:

CREATE VIEW ABC_VW...