Use "With (nolock)" hint with table name in query,

for example

select a.*

from <<tbl_aa>> a with (nolock)

Join <<tbl_bb>> b with (nolock) on a.aa_id = b.bb_id

--Note: You need to replace...