Thanks for reply.

This query is the part of a procedure.

I think no different these two query, but output of query 1 is without any row. In other word, "Inner Join dbo.CustomerCreditD" is cause of the result.