Hi dear,

Sorry for addee this question as a poll

But i have searched in goggle and many other site also but i m not getting a correct answer...................

Any way i remember...

this query Executing fine and displayed currect output in SQL2000

SELECT *

FROM tbl_dxu_entitydetails WITH (NOLOCK), tbl_dxu_templatedetails WITH (NOLOCK), tbl_DXU_LookUp WITH (NOLOCK)

WHERE ...

Hi,

Join will not create any problem if u have proper indexes on tables..... And also if posible then use "with (NO LOCK)" on table at the time of selecting records...