>>SELECT Client.Numero FROM Client >> WHERE Client.NoEntity=@NoEntity AND Client.Fic_Date<@Fic_Date >> AND Client.Loss_Code=@Loss_Code AND Client.CType=@CType >> AND EXISTS ( SELECT 1 FROM Invoice WHERE Client.Numero=Invoice.NoClient AND Invoice.Amount=@Amount) >>>
SELECT Client.Numero FROM Client WITH (NOLOCK) WHERE Client.NoEntity=@NoEntity AND Client.Fic_Date<@Fic_Date AND Client.Loss_Code=@Loss_Code AND Client.CType=@CType AND EXISTS ( SELECT 1 FROM Invoice WITH (NOLOCK) WHERE Client.Numero=Invoice.NoClient AND Invoice.Amount=@Amount)