============================================
BEGIN TRAN
SELECT P.*,C.name cname FROM Product P WITH (NOLOCK) LEFT JOIN ProductCtg C ON P.ctgidx=C.idx WHERE P.idx='5041'
ROLLBACK
============================================